WISE OWL EXERCISES
POWER BI EXERCISES
DAX EXERCISES
Free DAX exercises
This page lists 21 DAX exercises. You can use the menu 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.
This page has 0 threads
Add post