2 Replies Latest reply on Sep 18, 2018 10:05 PM by Minoy Jose

    Calculated field to get value of a specific field for previous month value of a date field

    Minoy Jose

      Hi Everyone,

       

      I am new to Tableau and I am having trouble in creating a calculated field.

       

      I have data like this:

      Date
      Flag
      31-07-2018Y
      30-06-2018Y
      31-05-2018N
      30-04-2018Y

       

      I want to create a calculated field which gives the value of Flag for last month like this:

      Date
      Flag
      Prev Month Flag
      31-07-2018YY
      30-06-2018YN
      31-05-2018NY
      30-04-2018YN

       

      Could you please help?