PowerPivot exercises on MORE ADVANCED DAX FUNCTIONS

This page lists the 5 exercises about More advanced DAX functions in PowerPivot on our website:

Software: PowerPivot
Version: Excel 2013 and later
Topic: More advanced DAX functions
Level: Average difficulty
Course: PowerPivot / Excel Power BI
Exercise: Sorting total sales into ascending order, using the RANKX function.

Go to exercise ...

Software: PowerPivot
Version: Excel 2013 and later
Topic: More advanced DAX functions
Level: Average difficulty
Course: PowerPivot / Excel Power BI
Exercise: Create two measures, showing average price for the South and all other regions.

Go to exercise ...

Software: PowerPivot
Version: Excel 2016 and later
Topic: More advanced DAX functions
Level: Average difficulty
Course: PowerPivot / Excel Power BI
Exercise: Exclude a single animal from a pivot table, using CALCULATE combined with the VALUES function.

Go to exercise ...

Software: PowerPivot
Version: Excel 2016 and later
Topic: More advanced DAX functions
Level: Harder than average
Course: PowerPivot / Excel Power BI
Exercise: Group purchases into shopping centre size bands, using the EARLIER and FILTER functions.

Go to exercise ...

Software: PowerPivot
Version: Excel 2013 and later
Topic: More advanced DAX functions
Level: Harder than average
Course: PowerPivot / Excel Power BI
Exercise: Group sales into size bands using the EARLIER function.

Go to exercise ...

You can search our full list of Power BI exercises here, or why not have a look at our other Power BI training resources?

This page has 0 threads Add post