Forum Discussion
Calculating YTD
Hi, I am trying to calculate YTD by using TOTALYTD and the quick measure approach, but none of them seem to work. I have data with both actual data and forecasted data. The date table ranges from...
Hi mike87,
Please create a calendar table and link it to your model and then create your measure either with TOTALYTD or calculate with DATEYTD.
If it is not clear please share dummy data and I will make a try.
Ninter
Thank you for your response Interkoubess. The data I have presented is dummy data. The actual data has a calender table as well, but still the same issue.
I'm happy to share the data with you, but I don't know how to :S