DATE FUNCTIONS exercises

This page lists the 10 exercises about Date functions in PowerPivot on our website:

Software:	PowerPivot
Topic:	Date functions
Level:	Relatively easy
Exercise:	Use the SAMEPERIODLASTYEAR and DATEADD functions to show various statistics for total sales.

Show this exercise

Software:	PowerPivot
Topic:	Date functions
Level:	Relatively easy
Exercise:	Use the TOTALQTD and TOTALYTD functions to show total sales with quarterly and annual to-date figures.

Show this exercise

Software:	PowerPivot
Topic:	Date functions
Level:	Relatively easy
Exercise:	Use the TOTALYTD and TOTALQTD functions to show cumulative totals.

Show this exercise

Software:	PowerPivot
Topic:	Date functions
Level:	Average difficulty
Exercise:	Calculate total sales for the last year and the one before it.

Show this exercise

Software:	PowerPivot
Topic:	Date functions
Level:	Average difficulty
Exercise:	Use FIRSTDATE and LASTDATE to pick out the start/end values.

Show this exercise

Software:	PowerPivot
Topic:	Date functions
Level:	Average difficulty
Exercise:	Use the SAMEPERIODLASTYEAR and DATEADD functions to show comparison figures.

Show this exercise

Software:	PowerPivot
Topic:	Date functions
Level:	Average difficulty
Exercise:	Use the TOTALQTD function to accumulate quarter-to-date figures for each environment.

Show this exercise

Software:	PowerPivot
Topic:	Date functions
Level:	Harder than average
Exercise:	Compare YTD totals for two years, showing variance.

Show this exercise

Software:	PowerPivot
Topic:	Date functions
Level:	Harder than average
Exercise:	Use the DATESYTD, TOTALYTD, SAMEPERIODLASTYEAR and various other date functions to compare totals.

Show this exercise

Software:	PowerPivot
Topic:	Date functions
Level:	Harder than average
Exercise:	Use the PARALLELPERIOD function to show this quarter's total sales divided by the previous quarter's.

Show this exercise

You can search our full list of Power BI exercises here. Or why not learn to do them the right way on one of our Power BI training courses? You can attend our online training classes wherever you are in the world!

None of the exercises or supporting files may be copied in any form or used commercially without the prior written permission of Wise Owl (although you're welcome to use them for testing your own knowledge).

This page has 0 threads

Add a new post