EDX Lab 2 Exercise 3: Year to Date
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 SalesYTD Sales = TOTALYTD([Total Sales], 'Date'[Date])My answer: 136,956,026.68Correct answer: ?
LY YTD SalesLY YTD Sale = CALCULATE([Total Sales], SAMEPERIODLASTYEAR(, 'Date'[Date]))My answer: 4,990,799,422.97Correct answer: 272,629,284.10
YTD Sales Var YTD Sales Var = ([YTD Sales] - [LY YTD Sales])My answer: -4,853,843,396.29Correct answer: ?
YTD Sales Var %YTD Sales Var % = DIVIDE([YTD Sales Var],[LY YTD Sales])Correct answer: 49.76My answer: -97.26%
Eric (Montreal, Canada)
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 !
View solution in original post
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.
Help me.. I can't get it right. And I used 1 try already... 😞
Read the announcement for more information!
We're rolling out new Kudos Given badges. Find out how many Kudos you've given.
Get an overview of the events and great community content from November.
Find out where you can attend!