Free DAX exercises
You are welcome to try any of the 28 DAX exercises listed below, but please do not distribute them in any form without asking for our written permission first.
| Software: |
DAX |
| Topic: |
Calculated columns |
| Level: |
Relatively easy |
| Exercise: |
Divide one column by another, avoiding any divide-by-zero errors. |
| Software: |
DAX |
| Topic: |
Calculated columns |
| Level: |
Average difficulty |
| Exercise: |
Create two new calculated columns, one using context transition and one not. |
| Software: |
DAX |
| Topic: |
Calculated columns |
| Level: |
Average difficulty |
| Exercise: |
Look up columns from another table using the RELATED function. |
| Software: |
DAX |
| Topic: |
Calculated columns |
| Level: |
Average difficulty |
| Exercise: |
Use the SWITCH function to show program viewing figures in bands. |
| Software: |
DAX |
| Topic: |
Calculated columns |
| Level: |
Harder than average |
| Exercise: |
Use COUNTROWS and RELATEDTABLE to count the rows in different tables. |
| Software: |
DAX |
| Topic: |
Basic measures |
| Level: |
Relatively easy |
| Exercise: |
Create a variety of measures to report on film data. |
| Software: |
DAX |
| Topic: |
Basic measures |
| Level: |
Relatively easy |
| Exercise: |
Show the average Brexit REMAIN votes by creating a couple of simple measures. |
| Software: |
DAX |
| Topic: |
Basic measures |
| Level: |
Average difficulty |
| Exercise: |
Divide box office takings by budget to show the average profit margin for films. |
| Software: |
DAX |
| Topic: |
The CALCULATE function |
| Level: |
Relatively easy |
| Exercise: |
Remove the filter context using the CALCULATE function in a measure. |
| Software: |
DAX |
| Topic: |
The CALCULATE function |
| Level: |
Average difficulty |
| Exercise: |
Calculate the ratio between normal and multi-legged animals, using variables, CALCULATE and VALUES. |
| Software: |
DAX |
| Topic: |
The CALCULATE function |
| Level: |
Average difficulty |
| Exercise: |
Show ratios for a table of premier league results, using the CALCULATE function. |
| Software: |
DAX |
| Topic: |
The CALCULATE function |
| Level: |
Harder than average |
| Exercise: |
Sort Bake-Off viewing figures using the RANKX function. |
| Software: |
DAX |
| Topic: |
The VALUES function |
| Level: |
Average difficulty |
| Exercise: |
Create a measure in a card to give a Brexit report a dynamic title. |
| Software: |
DAX |
| Topic: |
The VALUES function |
| Level: |
Average difficulty |
| Exercise: |
Show a single product for each filter context using the VALUES function. |
| Software: |
DAX |
| Topic: |
The VALUES function |
| Level: |
Harder than average |
| Exercise: |
Add a slicer for units, and adjust table to divide film figures by unit chosen. |
| Software: |
DAX |
| Topic: |
The VALUES function |
| Level: |
Harder than average |
| Exercise: |
Omit certain columns from a matrix, using CALCULATE, VALUES and FILTER. |
| Software: |
DAX |
| Topic: |
The FILTER function |
| Level: |
Relatively easy |
| Exercise: |
Combine criteria using FILTER to sum only certain purchases. |
| Software: |
DAX |
| Topic: |
Understanding EARLIER |
| Level: |
Average difficulty |
| Exercise: |
Create a cumulative total over dates using FILTER and EARLIER functions. |
| Software: |
DAX |
| Topic: |
Understanding EARLIER |
| Level: |
Harder than average |
| Exercise: |
Work out how many breaks you'll need for each film using EARLIER. |
| Software: |
DAX |
| Topic: |
Calendars and dates |
| Level: |
Relatively easy |
| Exercise: |
Create various date functions to report on sightings of harbour porpoises. |
| Software: |
DAX |
| Topic: |
Calendars and dates |
| Level: |
Relatively easy |
| Exercise: |
Show cumulative sales for each quarter, and figures for the previous quarter. |
| Software: |
DAX |
| Topic: |
Calendars and dates |
| Level: |
Average difficulty |
| Exercise: |
Add two calendars to a data model to compare two different expense dates. |
| Software: |
DAX |
| Topic: |
Calendars and dates |
| Level: |
Average difficulty |
| Exercise: |
Link a staff table to a calendar table twice, then use USERELATIONSHIP. |
| Software: |
DAX |
| Topic: |
Calendars and dates |
| Level: |
Average difficulty |
| Exercise: |
Show the cumulative proportion of the previous month's total sales, using various date functions. |
| Software: |
DAX |
| Topic: |
Advanced date functions |
| Level: |
Harder than average |
| Exercise: |
Create 3 complicated time-intelligence formulae using DAX. |
| Software: |
DAX |
| Topic: |
DAX queries |
| Level: |
Relatively easy |
| Exercise: |
Write a DAX query to list out high-scoring remain voting areas for Brexit. |
| Software: |
DAX |
| Topic: |
DAX queries |
| Level: |
Average difficulty |
| Exercise: |
Use the SUMMARIZE function to show average film length by genre. |
| Software: |
DAX |
| Topic: |
Variables |
| Level: |
Relatively easy |
| Exercise: |
Work out the ratio of wins to nominations for films using variables. |
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 Power BI training courses? You can attend our online training classes wherever you are in the world!
