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.

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.

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.

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.

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.

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