Forum Discussion

ericet's avatar
ericet
Icon for Helper I rankHelper I
8 years ago
Solved

EDX Lab 2 Exercise 3: Year to Date

EDX Lab 2 Exercise 3: Year to Date   Hello Everyone, Trying to learn Power BI but I find it more difficult then I thought or maybe the course itself is not clear enough…   I’m now at Lab 2 Exerc...
Tutorial Requests
  • ericet's avatar
    ericet
    8 years ago

    Good news, I started again from the beginning (after a good nights sleep) and I was

    able to do it again without any problems !

     

    :-)

     

    Thanks

     

    Eric

zeynusu's avatar
zeynusu
New Member
6 years ago

YTD Sales
YTD Sales = TOTALYTD([Total Sales], 'Date'[Date])
Correct answer: 136,956,026.68

 

LY YTD Sales
LY YTD Sale = CALCULATE([Total Sales], SAMEPERIODLASTYEAR(, 'Date'[Date]))
Correct answer: 272,629,284.10

 

YTD Sales Var 
YTD Sales Var = ([YTD Sales] - [LY YTD Sales])
Correct answer: -135,673,257.42

 

YTD Sales Var %
YTD Sales Var % = DIVIDE([YTD Sales Var],[LY YTD Sales])
My answer: -49.76%

Süleyman Zeynul from Warsaw