EXERCISE TOPIC▼
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 |
| Courses: | Fast track Power BI/DAXDAX |
| Exercise: | Divide one column by another, avoiding any divide-by-zero errors. |
| Software: | DAX |
| Version: | |
| Topic: | Basic measures |
| Level: | Relatively easy |
| Courses: | Fast track Power BI/DAXDAX |
| Exercise: | Create a variety of measures to report on film data. |
| Software: | DAX |
| Version: | |
| Topic: | Calendars and dates |
| Level: | Relatively easy |
| Courses: | Fast track Power BI/DAXDAX |
| 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 |
| Courses: | Fast track Power BI/DAXDAX |
| Exercise: | Remove the filter context using the CALCULATE function in a measure. |
| Software: | DAX |
| Version: | |
| Topic: | The FILTER function |
| Level: | Relatively easy |
| Courses: | Fast track Power BI/DAXDAX |
| Exercise: | Combine criteria using FILTER to sum only certain purchases. |
| Software: | DAX |
| Version: | |
| Topic: | Variables |
| Level: | Relatively easy |
| Courses: | Fast track Power BI/DAXDAX |
| Exercise: | Work out the ratio of wins to nominations for films using variables. |
| Software: | DAX |
| Version: | |
| Topic: | Calculated columns |
| Level: | Average difficulty |
| Courses: | Fast track Power BI/DAXDAX |
| Exercise: | Use the SWITCH function to show program viewing figures in bands. |
| Software: | DAX |
| Version: | |
| Topic: | Calculated columns |
| Level: | Average difficulty |
| Courses: | Fast track Power BI/DAXDAX |
| Exercise: | Look up columns from another table using the RELATED function. |
| Software: | DAX |
| Version: | |
| Topic: | Basic measures |
| Level: | Average difficulty |
| Courses: | Fast track Power BI/DAXDAX |
| 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 |
| Courses: | Fast track Power BI/DAXDAX |
| Exercise: | Create a measure in a card to give a Brexit report a dynamic title. |
| Software: | DAX |
| Version: | |
| Topic: | Calculated columns |
| Level: | Average difficulty |
| Courses: | Fast track Power BI/DAXDAX |
| Exercise: | Create two new calculated columns, one using context transition and one not. |
| Software: | DAX |
| Version: | |
| Topic: | The VALUES function |
| Level: | Average difficulty |
| Courses: | Fast track Power BI/DAXDAX |
| 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 |
| Courses: | Fast track Power BI/DAXDAX |
| Exercise: | Link a staff table to a calendar table twice, then use USERELATIONSHIP. |
| Software: | DAX |
| Version: | |
| Topic: | The VALUES function |
| Level: | Harder than average |
| Courses: | Fast track Power BI/DAXDAX |
| 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 |
| Courses: | Fast track Power BI/DAXDAX |
| Exercise: | Use COUNTROWS and RELATEDTABLE to count the rows in different tables. |
| Software: | DAX |
| Version: | |
| Topic: | Advanced date functions |
| Level: | Harder than average |
| Courses: | Fast track Power BI/DAXDAX |
| 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 |
| Courses: | Fast track Power BI/DAXDAX |
| 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