EDX Lab 2 Exercise 3: Year to Date

[ericet]

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)

[zeynusu]

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

[Anonymous]

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

[v-jiascu-msft]

Hi @ericet,

Can you share the sample data please? You also can refer to Power-BI-Desktop-Modelling-gt-Lab-2-gt-Exercise-3-Year-to-Date and EdX-Specific-Training-Discussion/Lab-2-Exercise-2-and-Exercise-3.

Best Regards,

Dale

[ericet · Accepted solution]

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]

Eric,

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

[ericet]

Hi, just write me an email and I will see if I can help you.

Eric