Microsoft PowerPivot 2010 training exercises | Date calculations

Showing exercises 1-4 (out of 4)

Category: PowerPivot 2010
Topic: Date calculations
Level: Relatively easy
Course:
Exercise: Use the TOTALYTD and TOTALQTD functions to show cumulative totals.

Go to exercise ...

Category: PowerPivot 2010
Topic: Date calculations
Level: Average difficulty
Course:
Exercise: Use FIRSTDATE and LASTDATE to pick out the start/end values.

Go to exercise ...

Category: PowerPivot 2010
Topic: Date calculations
Level: Average difficulty
Course:
Exercise: Calculate total sales for the last year and the one before it.

Go to exercise ...

Category: PowerPivot 2010
Topic: Date calculations
Level: Harder than average
Course:
Exercise: Compare YTD totals for two years, showing variance.

Go to exercise ...

This page has 0 threads Add post