EXERCISE TOPIC▼
POWER BI EXERCISES▼
DAX EXERCISES▼
Free DAX exercises
This page lists 28 DAX exercises. You can use the menu on the left to show just exercises for a specific topic.
This page lists 28 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 and 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 and DAXDAX |
| Exercise: | Show the average Brexit REMAIN votes by creating a couple of simple measures. |
| Software: | DAX |
| Version: | |
| Topic: | Basic measures |
| Level: | Relatively easy |
| Courses: | Fast track Power BI and 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 and DAXDAX |
| Exercise: | Show cumulative sales for each quarter, and figures for the previous quarter. |
| Software: | DAX |
| Version: | |
| Topic: | Calendars and dates |
| Level: | Relatively easy |
| Courses: | Fast track Power BI and 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 and 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 and DAXDAX |
| Exercise: | Combine criteria using FILTER to sum only certain purchases. |
| Software: | DAX |
| Version: | |
| Topic: | Variables |
| Level: | Relatively easy |
| Courses: | Fast track Power BI and 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 and 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 and DAXDAX |
| Exercise: | Look up columns from another table using the RELATED function. |
| Software: | DAX |
| Version: | |
| Topic: | Calendars and dates |
| Level: | Average difficulty |
| Courses: | Fast track Power BI and DAXDAX |
| Exercise: | Add two calendars to a data model to compare two different expense dates. |
| Software: | DAX |
| Version: | |
| Topic: | Basic measures |
| Level: | Average difficulty |
| Courses: | Fast track Power BI and 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: | Calendars and dates |
| Level: | Average difficulty |
| Courses: | Fast track Power BI and DAXDAX |
| Exercise: | Show the cumulative proportion of the previous month's total sales, using various date functions. |
| Software: | DAX |
| Version: | |
| Topic: | The VALUES function |
| Level: | Average difficulty |
| Courses: | Fast track Power BI and 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 and 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 and DAXDAX |
| Exercise: | Show a single product for each filter context using the VALUES function. |
| Software: | DAX |
| Version: | |
| Topic: | The CALCULATE function |
| Level: | Average difficulty |
| Courses: | Fast track Power BI and DAXDAX |
| Exercise: | Show ratios for a table of premier league results, using the CALCULATE 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 and DAXDAX |
| Exercise: | Link a staff table to a calendar table twice, then use USERELATIONSHIP. |
| Software: | DAX |
| Version: | |
| Topic: | The CALCULATE function |
| Level: | Average difficulty |
| Courses: | Fast track Power BI and DAXDAX |
| Exercise: | Calculate the ratio between normal and multi-legged animals, using variables, CALCULATE and VALUES. |
| Software: | DAX |
| Version: | |
| Topic: | The VALUES function |
| Level: | Harder than average |
| Courses: | Fast track Power BI and 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 and 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 and 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 VALUES function |
| Level: | Harder than average |
| Courses: | Fast track Power BI and DAXDAX |
| Exercise: | Omit certain columns from a matrix, using CALCULATE, VALUES and FILTER. |
| Software: | DAX |
| Version: | |
| Topic: | The CALCULATE function |
| Level: | Harder than average |
| Courses: | Fast track Power BI and 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