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

Lab 2 - can't get a start with LY YTD Sales measure

Hi

 

I'm using this formula but I keep getting an error:

 

YTD Total Sales = TOTALYTD([Sales],'Date'[Date], "12/31")

 

Can anyone help?

2 REPLIES 2
Highlighted
Super User
Super User

Re: Lab 2 - can't get a start with LY YTD Sales measure

Drop it down to just YTD Total Sales = TOTALYTD([Sales],'Date'[Date]) without specifying an ending date. I never use ending dats for the current year.

DominikPetri
Advisor

Re: Lab 2 - can't get a start with LY YTD Sales measure

You only need the 3rd parameter if your fiscal year does NOT end of 12/31

 

Hope this helps...

Dominik.

 

Please mark Accept as Solution if your question is answered. Kudos gladly accepted. ⇘