WISE OWL EXERCISES
POWER BI EXERCISES
DAX EXERCISES
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. |
| Software: | DAX |
| Version: | |
| Topic: | Basic measures |
| Level: | Relatively easy |
| Course: | DAX |
| Exercise: | Create a variety of measures to report on film data. |
| Software: | DAX |
| Version: | |
| Topic: | Calendars and dates |
| Level: | Relatively easy |
| Course: | DAX |
| Exercise: | Create various date functions to report on sightings of harbour porpoises. |
| 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. |
| Software: | DAX |
| Version: | |
| Topic: | The CALCULATE function |
| Level: | Relatively easy |
| Course: | DAX |
| Exercise: | Remove the filter context using the CALCULATE function in a measure. |
| Software: | DAX |
| Version: | |
| Topic: | The FILTER function |
| Level: | Relatively easy |
| Course: | DAX |
| Exercise: | Combine criteria using FILTER to sum only certain purchases. |
| Software: | DAX |
| Version: | |
| Topic: | Calculated columns |
| Level: | Average difficulty |
| Course: | DAX |
| Exercise: | Use the SWITCH function to show program viewing figures in bands. |
| Software: | DAX |
| Version: | |
| Topic: | Calculated columns |
| Level: | Average difficulty |
| Course: | DAX |
| Exercise: | Look up columns from another table using the RELATED function. |
| 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. |
| Software: | DAX |
| Version: | |
| Topic: | DAX queries |
| Level: | Average difficulty |
| Course: | DAX |
| Exercise: | Use the SUMMARIZE function to show average film length by genre. |
| 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. |
| Software: | DAX |
| Version: | |
| Topic: | Calculated columns |
| Level: | Average difficulty |
| Course: | DAX |
| Exercise: | Create two new calculated columns, one using context transition and one not. |
| 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. |
| Software: | DAX |
| Version: | |
| Topic: | Understanding EARLIER |
| Level: | Average difficulty |
| Course: | DAX |
| Exercise: | Create a cumulative total over dates using FILTER and EARLIER functions. |
| 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. |
| 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. |
| Software: | DAX |
| Version: | |
| Topic: | Calculated columns |
| Level: | Harder than average |
| Course: | DAX |
| Exercise: | Use COUNTROWS and RELATEDTABLE to count the rows in different tables. |
| Software: | DAX |
| Version: | |
| Topic: | Advanced date functions |
| Level: | Harder than average |
| Course: | DAX |
| Exercise: | Create 3 complicated time-intelligence formulae using DAX. |
| 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. |
| Software: | DAX |
| Version: | |
| Topic: | The CALCULATE function |
| Level: | Harder than average |
| Course: | DAX |
| Exercise: | Sort Bake-Off viewing figures using the RANKX function. |
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