Microsoft PowerPivot 2010 training exercises | FILTER and CALCULATE

Showing exercises 1-8 (out of 8)

Category: PowerPivot 2010
Topic: FILTER and CALCULATE
Level: Relatively easy
Course:
Exercise: Use ALL and CALCULATE to get proportions of totals for regions.

Go to exercise ...

Category: PowerPivot 2010
Topic: FILTER and CALCULATE
Level: Relatively easy
Course:
Exercise: Divide sales by 4 legs and other for a measure, using the FILTER function.

Go to exercise ...

Category: PowerPivot 2010
Topic: FILTER and CALCULATE
Level: Average difficulty
Course:
Exercise: Use the RANKX function to order total sales over species.

Go to exercise ...

Category: PowerPivot 2010
Topic: FILTER and CALCULATE
Level: Average difficulty
Course:
Exercise: Use FILTER and ALL to show sales as a proportion of one region's total.

Go to exercise ...

Category: PowerPivot 2010
Topic: FILTER and CALCULATE
Level: Average difficulty
Course:
Exercise: Create measure using CALCULATE and ALL to get ratios against total.

Go to exercise ...

Category: PowerPivot 2010
Topic: FILTER and CALCULATE
Level: Average difficulty
Course:
Exercise: Exclude a month from totals using the VALUES function to retain context.

Go to exercise ...

Category: PowerPivot 2010
Topic: FILTER and CALCULATE
Level: Harder than average
Course:
Exercise: Filter calculated sums to compare two stores' sales figures.

Go to exercise ...

Category: PowerPivot 2010
Topic: FILTER and CALCULATE
Level: Harder than average
Course:
Exercise: Create a calculated column using EARLIER to show previous joiner count.

Go to exercise ...

This page has 0 threads Add post