Reply
Frequent Visitor
Posts: 6
Registered: ‎06-19-2016
Accepted Solution

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?


Accepted Solutions
Established Member
Posts: 135
Registered: ‎11-28-2015

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

[ Edited ]

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)

View solution in original post


All Replies
Established Member
Posts: 135
Registered: ‎11-28-2015

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

[ Edited ]

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
Posts: 3
Registered: ‎06-30-2016

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
Posts: 3
Registered: ‎06-30-2016

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
Posts: 6
Registered: ‎06-19-2016

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

Frequent Visitor
Posts: 6
Registered: ‎02-28-2017

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 ?

Regular Visitor
Posts: 37
Registered: ‎03-10-2016

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

Frequent Visitor
Posts: 6
Registered: ‎02-28-2017

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

i successfully completed my labs and got the certificate Smiley Happy 

Regular Visitor
Posts: 37
Registered: ‎03-10-2016

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

Congratulations, Levajar Smiley Very Happy

Frequent Visitor
Posts: 6
Registered: ‎02-28-2017

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 ?