This page lists the
10 exercises about Date functions in PowerPivot on our website:
| Software: |
PowerPivot |
| Version: |
Excel 2016 and later |
| Topic: |
Date functions |
| Level: |
Relatively easy |
|
Course:
|
|
| 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:
|
|
| 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:
|
|
| Exercise: |
Use the TOTALQTD function to accumulate quarter-to-date figures for each environment. |
Go to exercise ...
| Software: |
PowerPivot |
| Version: |
Excel 2013 and later |
| Topic: |
Date functions |
| Level: |
Average difficulty |
|
Course:
|
|
| Exercise: |
Use the SAMEPERIODLASTYEAR and DATEADD functions to show comparison figures. |
Go to exercise ...
| Software: |
PowerPivot |
| Version: |
Excel 2016 and later |
| Topic: |
Date functions |
| Level: |
Harder than average |
|
Course:
|
|
| 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:
|
|
| Exercise: |
Use the DATESYTD, TOTALYTD, SAMEPERIODLASTYEAR and various other date functions to compare totals. |
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
