Calculating YTD

[mike87]

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 2017 to 2019. When I try to calculate YTD I get the sum of revenue for the last year in the data set.

How can I get the YTD revenue for 2018 (01.01.2018-01.03.2018)? 

 Data setTOTALYTDQuick measure YTDBoth approaches on the left, and the revenue over the 3 years on the right

[Interkoubess]

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

[mike87]

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