cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
constantLearner Frequent Visitor
Frequent Visitor

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

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.

 

 

2 ACCEPTED SOLUTIONS

Accepted Solutions
SamLester Established Member
Established Member

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) 

zbreimayer Frequent Visitor
Frequent Visitor

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.

4 REPLIES 4
SamLester Established Member
Established Member

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) 

zbreimayer Frequent Visitor
Frequent Visitor

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.

Alobaidi2017 Frequent Visitor
Frequent Visitor

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
Alobaidi2017 Frequent Visitor
Frequent Visitor

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