I'm using this formula but I keep getting an error:
YTD Total Sales = TOTALYTD([Sales],'Date'[Date], "12/31")
Can anyone help?
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.
You only need the 3rd parameter if your fiscal year does NOT end of 12/31
Hope this helps...