Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
ericet
Helper I
Helper I

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)

 

1 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

View solution in original post

6 REPLIES 6
zeynusu
New Member

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
Not applicable

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
Employee
Employee

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

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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...  😞

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

Eric

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.