Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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)
Solved! Go to 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
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
I used date field from Sales table instead of Date table and ended up getting wrong result. Any idea why this happened?
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
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
Eric,
Help me.. I can't get it right. And I used 1 try already... 😞
User | Count |
---|---|
141 | |
113 | |
104 | |
78 | |
64 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |