Forum Discussion
Anonymous
8 years agoNot applicable
Dim Date Error
Hey Guys, Newbie here. I am trying to calculate YTD Sales using the following Formula: Sales YTD = TOTALYTD([Sales], DimDate[CalendarDate].[Date]) Sales exists in a fact table and DimDate...
v-danhe-msft
8 years agoMicrosoft Employee
Hi Anonymous,
Based on my test, it could work on my side, could you please offer me your data stucture or pbix if possible?
Also you can test with our sample report on your side.
https://www.dropbox.com/s/dc8ms0usflhrbch/Dim%20Date%20Error.pbix?dl=0
Regards,
Daniel He