cancel
Showing results for
Search instead for
Did you mean:
Frequent Visitor

## 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
Frequent Visitor

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

New Member

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

Microsoft

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.
Frequent Visitor

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

New Member

Eric,

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

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

Eric

## Helpful resources

Announcements

#### 2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

#### Check it out!

Click here to read more about the July 2021 Updates

#### Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

Top Solution Authors
Top Kudoed Authors