Microsoft Power BI - Excel 2013 training exercises | The CALCULATE function

Showing exercises 1-4 (out of 4)

Category: Power BI - Excel 2013
Topic: The CALCULATE function
Level: Relatively easy
Course: PowerPivot / Excel Power BI
Exercise: Use the CALCULATE function to pick out only transactions whose price is a given amount.

Go to exercise ...

Category: Power BI - Excel 2013
Topic: The CALCULATE function
Level: Average difficulty
Course: PowerPivot / Excel Power BI
Exercise: Use CALCULATE to work out the ratio of total sales to sales for a specific type of animal.

Go to exercise ...

Category: Power BI - Excel 2013
Topic: The CALCULATE function
Level: Harder than average
Course: PowerPivot / Excel Power BI
Exercise: Use AVERAGEX to find average ratios, then CALCULATE to avoid divide-by-zero errors.

Go to exercise ...

Category: Power BI - Excel 2013
Topic: The CALCULATE function
Level: Harder than average
Course: PowerPivot / Excel Power BI
Exercise: Omitting a particular shopping centre from totals, using the VALUES function.

Go to exercise ...

This page has 0 threads Add post