- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

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

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content

06-19-2016 04:17 AM

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?

Solved! Go to Solution.

Accepted Solutions

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

[ Edited ]- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content

06-19-2016 08:50 AM - edited 06-19-2016 08:59 AM

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)

All Replies

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

[ Edited ]- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content

06-19-2016 08:50 AM - edited 06-19-2016 08:59 AM

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)

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

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content

06-30-2016 03:50 PM

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.

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

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content

06-30-2016 03:54 PM

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.

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

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content

07-01-2016 10:55 PM

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

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

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content

02-28-2017 09:12 PM

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

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content

03-01-2017 12:13 AM

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

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

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content

03-06-2017 08:08 AM

i successfully completed my labs and got the certificate

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

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content

03-08-2017 06:57 PM

Congratulations, Levajar

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

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content

03-28-2017 12:24 PM

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 ?