2 Replies Latest reply on May 3, 2018 10:50 PM by Yadan Wei

    How to get difference between two value with different date?

    Yadan Wei

      When I want to draw a table to show prior price and price change, I don't know how to do it. Here is my original data and target table


      Original data

      Effective DateMarket Price


      Table needed

      when I filter effective date to  2017-12-31, it will show data below


      Prior Price
      Market Price
      Price Change


      The same logic applies to 2018-3-31

      Prior PriceMarket Price
      Price Change


      I cannot upload a workbook cause company restriction.