4 Replies Latest reply on May 5, 2018 2:41 AM by sudheer.kumar.5

    How to add X number of months to a data point and have it return the measure value for that month in 36 months?

    Ava Kingsley

      Hi Tableau community,

       

      I have monthly car sales numbers going back a few years. Let's say sales in Jan 2013 were 1,000. I would like to create a calc where I can say take Jan 2013 sales, add 36 months, and return the measure value of 1,000 for Jan 2016 and so-on for a number of months.

       

      Is this possible? I am not very familiar with calcs that include dates and returning a measure from a previous date X number of months later.

       

      Thanks,

      Ava