cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
constantLearner Frequent Visitor
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 Smiley Sad

 

Any hints on where i might be going wrong?

1 ACCEPTED SOLUTION

Accepted Solutions
SamLester Established Member
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
SamLester Established Member
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)

ReportChallenge Frequent Visitor
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.

ReportChallenge Frequent Visitor
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.

constantLearner Frequent Visitor
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.

 

Percentage.JPG

Levajar Frequent Visitor
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 ?

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

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

 

Capture.PNG

Levajar Frequent Visitor
Frequent Visitor

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

i successfully completed my labs and got the certificate Smiley Happy 

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

Congratulations, Levajar Smiley Very Happy

Levajar Frequent Visitor
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 ?