5 Replies Latest reply on Jan 22, 2019 7:54 AM by Darren Gage

    Dateadd Increment from data

    Darren Gage

      Hi

       

      I'm new to Tableau and am looking to migrate an excel report into a Tableau dashboard. I have a calculated field that adds months onto a date but the months are pulled from a column in another data set. I have used the DATEADD function to add a static value / increment / interval (not sure of the correct term) ie add 1 month, but how do I replace the fixed value with a field from the data?

       

      DATEADD('month',1,[Date])

       

      to

       

      DATEADD('month',[month value],[Date])

       

      Thanks