## EdX Specific Training Discussion Forum

Frequent Visitor
Posts: 6
Registered: ‎06-19-2016

# 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: 135
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.

All Replies
Established Member
Posts: 135
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.

Highlighted
Frequent Visitor
Posts: 2
Registered: Monday

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

Hi @zbreimayer i got 0.03 as well. Could you please show me how to change the 0.03 to % datatype to get the right answer? Thanks.