EXERCISE TOPIC▼
POWER BI EXERCISES▼
DAX EXERCISES▼
DAX | Advanced date functions exercise | Fill in three time intelligence functions in a report
This exercise is provided to allow potential course delegates to choose the correct Wise Owl Microsoft training course, and may not be reproduced in whole or in part in any format without the prior written consent of Wise Owl.
You can learn how to do this exercise if you attend one of more of the courses listed below!
| Software ==> | DAX (21 exercises) |
| Version ==> | |
| Topic ==> | Advanced date functions (1 exercise) |
| Level ==> | Harder than average |
| Courses ==> | Fast track DAX / DAX |
You need a minimum screen resolution of about 700 pixels width to see our exercises. This is because they contain diagrams and tables which would not be viewable easily on a mobile phone or small laptop. Please use a larger tablet, notebook or desktop computer, or change your screen resolution settings.
Open the Power BI report in the above folder, and see how many of the gaps you can fill in, given the time you have available!
Create 3 measures using the table below - the screen shot below shows what these should show.
Here are the measures you need to create:
| No. | Measure | Thoughts |
|---|---|---|
| 1 | % of previous quarter | For each quarter, what percentage the total quantity sold constitutes of the same figure for the previous quarter. |
| 2 | YTD % of all previous year | For each time period, the cumulative year-to-date figure divided by total quantity sold for the whole of the previous year. |
| 3 | 3-month moving average | The average of the total quantity sold for the previous 3 months. |
Here's what Wise Owl think the answers should look like!
The start of the table, with the 3 measures filled in (referred to by abbreviated names to save space).
Save your file as Desperate measures, then close it down.