Free DAX exercises
You are welcome to try any of the 59 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: |
Create DAX calculated columns in Microsoft Power BI Desktop to generate new values for a list of tallest buildings. |
| 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: |
Relatively easy |
| Exercise: |
Use conditional functions like IF and SWITCH to add calculated columns to a Power BI data model of tallest buildings.. |
| Software: |
DAX |
| Topic: |
Calculated columns |
| Level: |
Relatively easy |
| Exercise: |
Use the RELATED function in DAX to create a calculated column for adding labels to a chart. |
| 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 conditional functions like IF, SWITCH, ISBLANK and AND to create calculated columns in a report on music tours. |
| Software: |
DAX |
| Topic: |
Calculated columns |
| Level: |
Average difficulty |
| Exercise: |
Use DAX to add calculated columns to a Power BI data model. |
| Software: |
DAX |
| Topic: |
Calculated columns |
| Level: |
Average difficulty |
| Exercise: |
Use the RELATED function in DAX to create calculated columns which reference values in other tables. |
| 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: |
Relatively easy |
| Exercise: |
Write basic measures in DAX to calculate statistics for the world's tallest buildings. |
| Software: |
DAX |
| Topic: |
Basic measures |
| Level: |
Average difficulty |
| Exercise: |
Create basic DAX measures to calculate statistics about music tours. |
| 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: |
Relatively easy |
| Exercise: |
Use the CALCULATE and KEEPFILTERS functions in DAX to alter the behaviour of context filters in Power BI visuals. |
| Software: |
DAX |
| Topic: |
The CALCULATE function |
| Level: |
Relatively easy |
| Exercise: |
Use the DAX Calculate function to add filters to measures in Power BI Desktop. |
| Software: |
DAX |
| Topic: |
The CALCULATE function |
| Level: |
Relatively easy |
| Exercise: |
Use the DAX CALCULATE function to replace context filters. |
| Software: |
DAX |
| Topic: |
The CALCULATE function |
| Level: |
Relatively easy |
| Exercise: |
Use the REMOVEFILTERS function in DAX to modify the filter context of measures in Power BI Desktop. |
| 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: |
Average difficulty |
| Exercise: |
Use the ALLEXCEPT function to remove multiple filters in a DAX measure in Power BI Desktop. |
| Software: |
DAX |
| Topic: |
The CALCULATE function |
| Level: |
Average difficulty |
| Exercise: |
Use the ALLSELECTED function to modify the way filters work. |
| Software: |
DAX |
| Topic: |
The CALCULATE function |
| Level: |
Average difficulty |
| Exercise: |
Use the CALCULATE function in DAX measures to add filters to expressions. |
| Software: |
DAX |
| Topic: |
The CALCULATE function |
| Level: |
Average difficulty |
| Exercise: |
Use the CROSSFILTER function in DAX measures to control the direction of relationships in a Power BI semantic model. |
| Software: |
DAX |
| Topic: |
The CALCULATE function |
| Level: |
Average difficulty |
| Exercise: |
Use the DAX CALCULATE function to replace existing context filters in Power BI visuals. |
| Software: |
DAX |
| Topic: |
The CALCULATE function |
| Level: |
Average difficulty |
| Exercise: |
Use the KEEPFILTERS function in DAX to modify the way context filters behave in Power BI Visuals. |
| Software: |
DAX |
| Topic: |
The CALCULATE function |
| Level: |
Average difficulty |
| Exercise: |
Use the REMOVEFILTERS function to alter the way context filters behave in DAX measures. |
| Software: |
DAX |
| Topic: |
The CALCULATE function |
| Level: |
Harder than average |
| Exercise: |
Sort Bake-Off viewing figures using the RANKX function. |
| Software: |
DAX |
| Topic: |
The CALCULATE function |
| Level: |
Harder than average |
| Exercise: |
Use the CALCULATE function in DAX to apply filters to measures in Power BI Desktop. |
| Software: |
DAX |
| Topic: |
The VALUES function |
| Level: |
Relatively easy |
| Exercise: |
Create a DAX measure to reference a disconnected slicer in a Power BI Desktop report. |
| Software: |
DAX |
| Topic: |
The VALUES function |
| Level: |
Relatively easy |
| Exercise: |
Use the SELECTEDVALUE and CONCATENATEX functions to create dynamic labels for visual in Power BI Desktop. |
| 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: |
Average difficulty |
| Exercise: |
Use DAX measures to create dynamic labels for visuals in a Power BI Desktop report. |
| 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: |
The FILTER function |
| Level: |
Relatively easy |
| Exercise: |
Use the FILTER function in a DAX measure to provide a filtered version of a table to other functions. |
| Software: |
DAX |
| Topic: |
The FILTER function |
| Level: |
Average difficulty |
| Exercise: |
Use the FILTER function in a DAX measure to provide a filtered version of a table to other functions. |
| Software: |
DAX |
| Topic: |
The FILTER function |
| Level: |
Harder than average |
| Exercise: |
Use the FILTER function in a DAX measure to provide a filtered version of a table to other functions. |
| 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: |
Import and configure a custom calendar table in Power BI Desktop. |
| 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: |
Calendars and dates |
| Level: |
Average difficulty |
| Exercise: |
Use Power BI's automatic calendar tables and time intelligence functions in DAX measures. |
| Software: |
DAX |
| Topic: |
Calendars and dates |
| Level: |
Harder than average |
| Exercise: |
Create DAX measures using time intelligence functions based on a custom calendar in Power BI Desktop. |
| 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: |
Use variables a DAX measures to break a long formula into separate steps. |
| Software: |
DAX |
| Topic: |
Variables |
| Level: |
Relatively easy |
| Exercise: |
Work out the ratio of wins to nominations for films using variables. |
| Software: |
DAX |
| Topic: |
Variables |
| Level: |
Average difficulty |
| Exercise: |
Use variables a DAX measures to break a long formula into separate steps. |
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!
