WISE OWL EXERCISES
POWER BI EXERCISES
POWERPIVOT EXERCISES
- PowerPivot data models (7)
- Pivot tables using PowerPivot (2)
- Using Excel tables (3)
- Using other data sources (1)
- Transforming data (Power Query) (7)
- Calculated columns (7)
- Measures (2)
- The CALCULATE function (15)
- More advanced DAX functions (5)
- Calendars (1)
- Date functions (10)
- Hierarchies (2)
- KPIs (5)
- Power View (4)
- Power BI Desktop overview (3)
- Power BI Desktop maps (1)
PowerPivot exercises on THE CALCULATE FUNCTION
This page lists the 15 exercises about The CALCULATE function in PowerPivot on our website:
| Software: | PowerPivot |
| Version: | Excel 2016 and later |
| Topic: | The CALCULATE function |
| Level: | Relatively easy |
| Course: | |
| Exercise: | Use the CALCULATE function to show percentages of row and column totals in a pivot table. |
| Software: | PowerPivot |
| Version: | Excel 2013 and later |
| Topic: | The CALCULATE function |
| Level: | Relatively easy |
| Course: | |
| Exercise: | Use the CALCULATE function to pick out only transactions whose price is a given amount. |
| Software: | PowerPivot |
| Version: | Excel 2010 and later |
| Topic: | The CALCULATE function |
| Level: | Relatively easy |
| Course: | |
| Exercise: | Use ALL and CALCULATE to get proportions of totals for regions. |
| Software: | PowerPivot |
| Version: | Excel 2010 and later |
| Topic: | The CALCULATE function |
| Level: | Relatively easy |
| Course: | |
| Exercise: | Divide sales by 4 legs and other for a measure, using the FILTER function. |
| Software: | PowerPivot |
| Version: | Excel 2016 and later |
| Topic: | The CALCULATE function |
| Level: | Average difficulty |
| Course: | |
| Exercise: | Use the CALCULATE function to show total sales for Northern powerhouse shopping centres. |
| Software: | PowerPivot |
| Version: | Excel 2010 and later |
| Topic: | The CALCULATE function |
| Level: | Average difficulty |
| Course: | |
| Exercise: | Use the RANKX function to order total sales over species. |
| Software: | PowerPivot |
| Version: | Excel 2010 and later |
| Topic: | The CALCULATE function |
| Level: | Average difficulty |
| Course: | |
| Exercise: | Use FILTER and ALL to show sales as a proportion of one region's total. |
| Software: | PowerPivot |
| Version: | Excel 2010 and later |
| Topic: | The CALCULATE function |
| Level: | Average difficulty |
| Course: | |
| Exercise: | Create measure using CALCULATE and ALL to get ratios against total. |
| Software: | PowerPivot |
| Version: | Excel 2016 and later |
| Topic: | The CALCULATE function |
| Level: | Average difficulty |
| Course: | |
| Exercise: | Create a ratio of sales between two different habitats, using the CALCULATE and SUMX functions. |
| Software: | PowerPivot |
| Version: | Excel 2010 and later |
| Topic: | The CALCULATE function |
| Level: | Average difficulty |
| Course: | |
| Exercise: | Exclude a month from totals using the VALUES function to retain context. |
| Software: | PowerPivot |
| Version: | Excel 2013 and later |
| Topic: | The CALCULATE function |
| Level: | Average difficulty |
| Course: | |
| Exercise: | Use CALCULATE to work out the ratio of total sales to sales for a specific type of animal. |
| Software: | PowerPivot |
| Version: | Excel 2013 and later |
| Topic: | The CALCULATE function |
| Level: | Harder than average |
| Course: | |
| Exercise: | Use AVERAGEX to find average ratios, then CALCULATE to avoid divide-by-zero errors. |
| Software: | PowerPivot |
| Version: | Excel 2010 and later |
| Topic: | The CALCULATE function |
| Level: | Harder than average |
| Course: | |
| Exercise: | Filter calculated sums to compare two stores' sales figures. |
| Software: | PowerPivot |
| Version: | Excel 2010 and later |
| Topic: | The CALCULATE function |
| Level: | Harder than average |
| Course: | |
| Exercise: | Create a calculated column using EARLIER to show previous joiner count. |
| Software: | PowerPivot |
| Version: | Excel 2013 and later |
| Topic: | The CALCULATE function |
| Level: | Harder than average |
| Course: | |
| Exercise: | Omitting a particular shopping centre from totals, using the VALUES 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