cancel
Showing results 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.

Here is what I got (and what the answer should be I think …)

YTD Sales
YTD Sales = TOTALYTD([Total Sales], 'Date'[Date])

LY YTD Sales
LY YTD Sale = CALCULATE([Total Sales], SAMEPERIODLASTYEAR(, 'Date'[Date]))

YTD Sales Var
YTD Sales Var = ([YTD Sales] - [LY YTD Sales])

YTD Sales Var %
YTD Sales Var % = DIVIDE([YTD Sales Var],[LY YTD Sales])

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Frequent Visitor

Re: EDX Lab 2 Exercise 3: Year to Date

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

4 REPLIES 4
Microsoft

Re: EDX Lab 2 Exercise 3: Year to Date

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

Re: EDX Lab 2 Exercise 3: Year to Date

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

Frequent Visitor

Re: EDX Lab 2 Exercise 3: Year to Date

Eric,

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

Frequent Visitor

Re: EDX Lab 2 Exercise 3: Year to Date

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

Eric

Announcements