EXERCISE TOPIC▼
POWER BI EXERCISES▼
POWERPIVOT EXERCISES▼
- PowerPivot data models (7)
- Pivot tables using PowerPivot (2)
- Using Excel tables (3)
- Using other data sources (1)
- Transforming data (Power Query) (7)
- Calculated columns (7)
- Measures (2)
- The CALCULATE function (15)
- More advanced DAX functions (5)
- Calendars (1)
- Date functions (10)
- Hierarchies (2)
- KPIs (5)
- Power View (4)
- Power BI Desktop overview (3)
- Power BI Desktop maps (1)
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. |
| 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?
This page has 0 threads
Add post