PowerPivot exercises on DATE FUNCTIONS

 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.
 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.
 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.
 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.
 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.
 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.
 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.
 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.
 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.
 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.

You can search our full list of Power BI exercises here, or why not have a look at our other Power BI training resources?