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.

Software ==> DAX  (28 exercises)
Version ==>
Topic ==> Advanced date functions  (1 exercise)
Level ==> Harder than average
Subject ==> Power BI training
Before you can do this exercise, you'll need to download and unzip this file (if you have any problems doing this, click here for help).

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!

Blank measures

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!

Measures filled in

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.

You can unzip this file to see the answers to this exercise, although please remember this is for your personal use only.
This page has 0 threads Add post