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 Exercise 3: Year to Date

 

I cannot validate any of my answers and I know that if, I get one of these wrong it will effect the other values.

 

PLEASE HELP, thanks in advance.

 

 

Here is what I got (and what the answer should be I think …)

 

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

 

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

 

YTD Sales Var 
YTD Sales Var = ([YTD Sales] - [LY YTD Sales])
My answer: -4,853,843,396.29
Correct answer: ?

 

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

 

Eric (Montreal, Canada)

 

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

6 Replies

    • ericet's avatar
      ericet
      Icon for Helper I rankHelper I
      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

      • Arenna's avatar
        Arenna
        New Member
        8 years ago

        Eric,

        Help me.. I can't get it right. And I used 1 try already...  :(

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    I used date field from Sales table instead of Date table and ended up getting wrong result. Any idea why this happened?

  • 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