cancel
Showing results for
Did you mean:
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
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)

Highlighted
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
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)

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

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.

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