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

1 REPLY 1
dhave Frequent Visitor
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