Reply
Frequent Visitor
Posts: 6
Registered: ‎06-19-2016
Accepted Solution

Power BI Desktop Modelling > Lab 2 > Exercise 2: Last Year Comparison

[ Edited ]

The answer i have calculated is incorrect for the following question: What is the figure for the Sales Var % measure?

 

Below are the values and DAX used to calculate the Sales Var %:

 

Total Sales = SUM(Sales[Revenue]) -> 5127755449.65

LY Sales = CALCULATE([Total Sales],SAMEPERIODLASTYEAR('Date'[Date])) -> 4990799422.97

Sales Var = [Total Sales] - [LY Sales] -> 136956026.68

Sales Var % = DIVIDE([Sales Var],[LY Sales]) -> 0.03

 

Can somebidy please let me the exact solution to get the answer as 2.74% as given in the course.

 

 


Accepted Solutions
Established Member
Posts: 136
Registered: ‎11-28-2015

Re: Power BI Desktop Modelling > Lab 2 > Exercise 2: Last Year Comparison

Take a look at the threads here for discussion on the sales variance percentage measure:

http://community.powerbi.com/t5/EdX-Specific-Training-Discussion/Lab2-questions-Sales-Var-value/m-p/...

http://community.powerbi.com/t5/EdX-Specific-Training-Discussion/Lab-2-Date/m-p/42254#U42254

 

The common problem people hit with this question is not creating the association between the Sales table and the Date table in the instructions, but there are other issues discussed in the two threads.

 

Thanks,
Sam Lester (MSFT) 

View solution in original post

Frequent Visitor
Posts: 5
Registered: ‎06-22-2016

Re: Power BI Desktop Modelling > Lab 2 > Exercise 2: Last Year Comparison

You have the right value, you just need to change it to % datatype and it will show 2 decimals instead of rounding.

View solution in original post


All Replies
Established Member
Posts: 136
Registered: ‎11-28-2015

Re: Power BI Desktop Modelling > Lab 2 > Exercise 2: Last Year Comparison

Take a look at the threads here for discussion on the sales variance percentage measure:

http://community.powerbi.com/t5/EdX-Specific-Training-Discussion/Lab2-questions-Sales-Var-value/m-p/...

http://community.powerbi.com/t5/EdX-Specific-Training-Discussion/Lab-2-Date/m-p/42254#U42254

 

The common problem people hit with this question is not creating the association between the Sales table and the Date table in the instructions, but there are other issues discussed in the two threads.

 

Thanks,
Sam Lester (MSFT) 

Frequent Visitor
Posts: 5
Registered: ‎06-22-2016

Re: Power BI Desktop Modelling > Lab 2 > Exercise 2: Last Year Comparison

You have the right value, you just need to change it to % datatype and it will show 2 decimals instead of rounding.

Frequent Visitor
Posts: 4
Registered: ‎04-19-2017

Re: Power BI Desktop Modelling > Lab 2 > Exercise 2: Last Year Comparison

Just switch the format of this measure to % and the value will be the correct answer.

 

Best wishes.

Highlighted
Frequent Visitor
Posts: 4
Registered: ‎04-19-2017

Re: Power BI Desktop Modelling > Lab 2 > Exercise 2: Last Year Comparison

Just change the format of this measure to percentage and you will get the correect answer.

 

Best wishes