cancel
Showing results for
Did you mean:
Frequent Visitor

## Lab 2, Exercice 3 - Failed to respond at the first questions but good on the second

Hello friends,

I'm working on the Lab2, Exe3 and since three hours i can't find the good result for the first question of this exercice.

Despite having the correct answer for the calculation of the YTD Sales Var % measure

the fisrt question appears false for the LY YTD Sales Measure. it's very curious because the second result depend to the first one.

My formulation for the first is : YTD Sales Var % = DIVIDE([YTD Sales var];[LY YTD Sales])

for the second : LY YTD Sales = CALCULATE([YTD Sales];SAMEPERIODLASTYEAR('Date'[Date]))

YTD Sales is : YTD Sales = TOTALYTD([Total Sales];'Date'[Date])

for the first one i found : 272 600 258.00

the second : was good (near -49 %)

If someone has a idea to help me, please check my formula and tell me.

Thanks a lot for your help

Denis

1 ACCEPTED SOLUTION

Accepted Solutions
Frequent Visitor

## Re: Lab 2, Exercice 3 - Failed to respond at the first questions but good on the second

Hello again,

I just solved my problem but without be sure this was the right problem.

In fact on my report i had a graph. a deleta this one and create it again and my value change....

And the first answer is right

Frequent Visitor

## Re: Lab 2, Exercice 3 - Failed to respond at the first questions but good on the second

Hello again,

I just solved my problem but without be sure this was the right problem.

In fact on my report i had a graph. a deleta this one and create it again and my value change....

And the first answer is right