PowerPivot exercises on DATE FUNCTIONS

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

Software: PowerPivot
Version: Excel 2010 and later
Topic: Date functions
Level: Relatively easy
Course: PowerPivot / Excel Power BI
Exercise: Use the TOTALYTD and TOTALQTD functions to show cumulative totals.

Go to exercise ...

Software: PowerPivot
Version: Excel 2016 and later
Topic: Date functions
Level: Relatively easy
Course: PowerPivot / Excel Power BI
Exercise: Use the SAMEPERIODLASTYEAR and DATEADD functions to show various statistics for total sales.

Go to exercise ...

Software: PowerPivot
Version: Excel 2013 and later
Topic: Date functions
Level: Relatively easy
Course: PowerPivot / Excel Power BI
Exercise: Use the TOTALQTD and TOTALYTD functions to show total sales with quarterly and annual to-date figures.

Go to exercise ...

Software: PowerPivot
Version: Excel 2016 and later
Topic: Date functions
Level: Average difficulty
Course: PowerPivot / Excel Power BI
Exercise: Use the TOTALQTD function to accumulate quarter-to-date figures for each environment.

Go to exercise ...

Software: PowerPivot
Version: Excel 2010 and later
Topic: Date functions
Level: Average difficulty
Course: PowerPivot / Excel Power BI
Exercise: Use FIRSTDATE and LASTDATE to pick out the start/end values.

Go to exercise ...

Software: PowerPivot
Version: Excel 2013 and later
Topic: Date functions
Level: Average difficulty
Course: PowerPivot / Excel Power BI
Exercise: Use the SAMEPERIODLASTYEAR and DATEADD functions to show comparison figures.

Go to exercise ...

Software: PowerPivot
Version: Excel 2010 and later
Topic: Date functions
Level: Average difficulty
Course: PowerPivot / Excel Power BI
Exercise: Calculate total sales for the last year and the one before it.

Go to exercise ...

Software: PowerPivot
Version: Excel 2016 and later
Topic: Date functions
Level: Harder than average
Course: PowerPivot / Excel Power BI
Exercise: Use the PARALLELPERIOD function to show this quarter's total sales divided by the previous quarter's.

Go to exercise ...

Software: PowerPivot
Version: Excel 2013 and later
Topic: Date functions
Level: Harder than average
Course: PowerPivot / Excel Power BI
Exercise: Use the DATESYTD, TOTALYTD, SAMEPERIODLASTYEAR and various other date functions to compare totals.

Go to exercise ...

Software: PowerPivot
Version: Excel 2010 and later
Topic: Date functions
Level: Harder than average
Course: PowerPivot / Excel Power BI
Exercise: Compare YTD totals for two years, showing variance.

Go to exercise ...

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