Forum Discussion

mike87's avatar
mike87
Frequent Visitor
8 years ago

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

Need Help

2 Replies

  • Interkoubess's avatar
    Interkoubess
    Solution Sage
    8 years ago

    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's avatar
      mike87
      Frequent Visitor
      8 years ago

      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