cancel
Showing results for
Did you mean:
Highlighted
Frequent Visitor

## Power BI Desktop Modelling > Lab 2 > Exercise 3: Year to Date

Can somebody please help me out to calculate the correct value for the following measure: YTD Sales Var %

Based on my calculations the answer is -0.50, which is incorrect

Any hints on where i might be going wrong?

1 ACCEPTED SOLUTION

Accepted Solutions
Established Member

## Re: Power BI Desktop Modelling > Lab 2 > Exercise 3: Year to Date

Did you format the measure as percentage? Also, it is asking for the absolute value, so make sure to drop the negative sign. If you update it to percentage and drop the negative sign, you may have the correct answer.

Thanks,
Sam Lester (MSFT)

11 REPLIES 11
Established Member

## Re: Power BI Desktop Modelling > Lab 2 > Exercise 3: Year to Date

Did you format the measure as percentage? Also, it is asking for the absolute value, so make sure to drop the negative sign. If you update it to percentage and drop the negative sign, you may have the correct answer.

Thanks,
Sam Lester (MSFT)

Frequent Visitor

## Re: Power BI Desktop Modelling > Lab 2 > Exercise 3: Year to Date

How do you even format the measure as a percentage?  I'm getting the wrong answer as well (.02) and can't decipher how to check that detail.

Frequent Visitor

## Re: Power BI Desktop Modelling > Lab 2 > Exercise 3: Year to Date

How do you even confirm you have the measure formatted as a percentage?  I too am getting the incorrect answer (.02), but am at a loss on next steps to correct myself.

Frequent Visitor

## Re: Power BI Desktop Modelling > Lab 2 > Exercise 3: Year to Date

In the Modelling tab select Format as 'Percentage'. You would get the correct answer in you have used the correct DAX expression.

Frequent Visitor

## Re: Power BI Desktop Modelling > Lab 2 > Exercise 3: Year to Date

If the answer is wrong for the LABS - will it affect for overall certificate ?

Member

## Re: Power BI Desktop Modelling > Lab 2 > Exercise 3: Year to Date

Hi, yes, the labs account for 65% of the total grade.

Frequent Visitor

## Re: Power BI Desktop Modelling > Lab 2 > Exercise 3: Year to Date

i successfully completed my labs and got the certificate

Member

## Re: Power BI Desktop Modelling > Lab 2 > Exercise 3: Year to Date

Congratulations, Levajar

Frequent Visitor

## Re: Power BI Desktop Modelling > Lab 2 > Exercise 3: Year to Date

Thanks @AnneSmith-LeX - would love to get more materials to have deep dive into it.

Is NLG comes with Power BI license or we need separate costs for it while integration with wordsmith or Narrative Science ?