## EdX Specific Training Discussion Forum

Highlighted
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: 144
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: 144
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.

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