Reply
Frequent Visitor
Posts: 3
Registered: ‎03-20-2016

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?

Super User
Posts: 756
Registered: ‎08-27-2015

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.

Highlighted
Advisor
Posts: 40
Registered: ‎11-19-2015

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