Free DAX exercises

This page lists 21 DAX exercises. You can use the menu on the left to show just exercises for a specific topic.

This page lists 21 DAX exercises. You can use the menu above to show just exercises for a specific topic.

Software: DAX
Version:
Topic: Calculated columns
Level: Relatively easy
Course: DAX
Exercise: Divide one column by another, avoiding any divide-by-zero errors.

Go to exercise ...

Software: DAX
Version:
Topic: Basic measures
Level: Relatively easy
Course: DAX
Exercise: Create a variety of measures to report on film data.

Go to exercise ...

Software: DAX
Version:
Topic: Calendars and dates
Level: Relatively easy
Course: DAX
Exercise: Create various date functions to report on sightings of harbour porpoises.

Go to exercise ...

Software: DAX
Version:
Topic: DAX queries
Level: Relatively easy
Course: DAX
Exercise: Write a DAX query to list out high-scoring remain voting areas for Brexit.

Go to exercise ...

Software: DAX
Version:
Topic: The CALCULATE function
Level: Relatively easy
Course: DAX
Exercise: Remove the filter context using the CALCULATE function in a measure.

Go to exercise ...

Software: DAX
Version:
Topic: The FILTER function
Level: Relatively easy
Course: DAX
Exercise: Combine criteria using FILTER to sum only certain purchases.

Go to exercise ...

Software: DAX
Version:
Topic: Variables
Level: Relatively easy
Course: DAX
Exercise: Work out the ratio of wins to nominations for films using variables.

Go to exercise ...

Software: DAX
Version:
Topic: Calculated columns
Level: Average difficulty
Course: DAX
Exercise: Use the SWITCH function to show program viewing figures in bands.

Go to exercise ...

Software: DAX
Version:
Topic: Calculated columns
Level: Average difficulty
Course: DAX
Exercise: Look up columns from another table using the RELATED function.

Go to exercise ...

Software: DAX
Version:
Topic: Basic measures
Level: Average difficulty
Course: DAX
Exercise: Divide box office takings by budget to show the average profit margin for films.

Go to exercise ...

Software: DAX
Version:
Topic: DAX queries
Level: Average difficulty
Course: DAX
Exercise: Use the SUMMARIZE function to show average film length by genre.

Go to exercise ...

Software: DAX
Version:
Topic: The VALUES function
Level: Average difficulty
Course: DAX
Exercise: Create a measure in a card to give a Brexit report a dynamic title.

Go to exercise ...

Software: DAX
Version:
Topic: Calculated columns
Level: Average difficulty
Course: DAX
Exercise: Create two new calculated columns, one using context transition and one not.

Go to exercise ...

Software: DAX
Version:
Topic: The VALUES function
Level: Average difficulty
Course: DAX
Exercise: Show a single product for each filter context using the VALUES function.

Go to exercise ...

Software: DAX
Version:
Topic: Understanding EARLIER
Level: Average difficulty
Course: DAX
Exercise: Create a cumulative total over dates using FILTER and EARLIER functions.

Go to exercise ...

Software: DAX
Version:
Topic: Calendars and dates
Level: Average difficulty
Course: DAX
Exercise: Link a staff table to a calendar table twice, then use USERELATIONSHIP.

Go to exercise ...

Software: DAX
Version:
Topic: The VALUES function
Level: Harder than average
Course: DAX
Exercise: Add a slicer for units, and adjust table to divide film figures by unit chosen.

Go to exercise ...

Software: DAX
Version:
Topic: Calculated columns
Level: Harder than average
Course: DAX
Exercise: Use COUNTROWS and RELATEDTABLE to count the rows in different tables.

Go to exercise ...

Software: DAX
Version:
Topic: Advanced date functions
Level: Harder than average
Course: DAX
Exercise: Create 3 complicated time-intelligence formulae using DAX.

Go to exercise ...

Software: DAX
Version:
Topic: Understanding EARLIER
Level: Harder than average
Course: DAX
Exercise: Work out how many breaks you'll need for each film using EARLIER.

Go to exercise ...

Software: DAX
Version:
Topic: The CALCULATE function
Level: Harder than average
Course: DAX
Exercise: Sort Bake-Off viewing figures using the RANKX function.

Go to exercise ...

You can search our full list of Power BI exercises here. Or why not learn to do them the right way on one of our classroom Power BI training courses in the UK, or on one of our live online Power BI courses wherever you are in the world?

This page has 0 threads Add post