3 Replies Latest reply on Oct 1, 2018 11:52 AM by Hari Ankem

    How to show the same day of last month's measure date?

    John Levine

      Hi guys,

       

      I have a data source like:

       

      date         sale

      6/1/19       200

      6/3/19       400

      6/4/19       100

      6/5/19       120

      7/1/19       500

      7/2/19       200

      7/3/19       600

      7/4/19       200

      7/5/19        440

       

       

       

      I want to show the sale data of the same day of last month, such as:

       

      date          sale       last month sale

      6/1/19       200

      6/3/19       400

      6/4/19       100

      6/5/19       120

      7/1/19       500       200

      7/2/19       200

      7/3/19       600       400

      7/4/19       200       100

      7/5/19       440       120

       

       

      I don't like to use lookup function, since there are gaps between the dates, you cannot simply use -30 to show the sales of 30 days ago

      How to do it?

       

      Thanks,

       

      John