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.

Go to exercise ...

Software: DAX
Version:
Topic: Basic measures
Level: Relatively easy
Course: DAX
Exercise: Create a variety of measures to report on film data.

Go to exercise ...

Software: DAX
Version:
Topic: Calendars and dates
Level: Relatively easy
Course: DAX
Exercise: Create various date functions to report on sightings of harbour porpoises.

Go to exercise ...

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.

Go to exercise ...

Software: DAX
Version:
Topic: The CALCULATE function
Level: Relatively easy
Course: DAX
Exercise: Remove the filter context using the CALCULATE function in a measure.

Go to exercise ...

Software: DAX
Version:
Topic: The FILTER function
Level: Relatively easy
Course: DAX
Exercise: Combine criteria using FILTER to sum only certain purchases.

Go to exercise ...

Software: DAX
Version:
Topic: Variables
Level: Relatively easy
Course: DAX
Exercise: Work out the ratio of wins to nominations for films using variables.

Go to exercise ...

Software: DAX
Version:
Topic: Calculated columns
Level: Average difficulty
Course: DAX
Exercise: Use the SWITCH function to show program viewing figures in bands.

Go to exercise ...

Software: DAX
Version:
Topic: Calculated columns
Level: Average difficulty
Course: DAX
Exercise: Look up columns from another table using the RELATED function.

Go to exercise ...

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.

Go to exercise ...

Software: DAX
Version:
Topic: DAX queries
Level: Average difficulty
Course: DAX
Exercise: Use the SUMMARIZE function to show average film length by genre.

Go to exercise ...

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.

Go to exercise ...

Software: DAX
Version:
Topic: Calculated columns
Level: Average difficulty
Course: DAX
Exercise: Create two new calculated columns, one using context transition and one not.

Go to exercise ...

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.

Go to exercise ...

Software: DAX
Version:
Topic: Understanding EARLIER
Level: Average difficulty
Course: DAX
Exercise: Create a cumulative total over dates using FILTER and EARLIER functions.

Go to exercise ...

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.

Go to exercise ...

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.

Go to exercise ...

Software: DAX
Version:
Topic: Calculated columns
Level: Harder than average
Course: DAX
Exercise: Use COUNTROWS and RELATEDTABLE to count the rows in different tables.

Go to exercise ...

Software: DAX
Version:
Topic: Advanced date functions
Level: Harder than average
Course: DAX
Exercise: Create 3 complicated time-intelligence formulae using DAX.

Go to exercise ...

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.

Go to exercise ...

Software: DAX
Version:
Topic: The CALCULATE function
Level: Harder than average
Course: DAX
Exercise: Sort Bake-Off viewing figures using the RANKX function.

Go to exercise ...

You can search our full list of Power BI exercises here.

This page has 0 threads Add post