3 Replies Latest reply on Sep 4, 2018 10:44 AM by Jim Dehner

    Identify change in a Measure Based on Dimension

    Chris Rosado

      Hello,

       

      I am trying to identify which Part Numbers have had an increase or decrease in their sell price since they were first sold (date). Ideally, a new dimension can be created that identifies this.

       

      So far I've been close by using MIN/MAX LODs with IF statements but haven't quite got there. Attached is a workbook.

       

         

      Part NumberOrder DateSell Price
      123A10/1/2017$10.00
      123A10/5/2017$10.00
      345B10/4/2017$5.00
      345B11/15/2017$7.00
      345B11/16/2017$7.00
      678C10/1/2017$8.00
      678C12/10/2017$6.00
      901D10/3/2017$100.00
      901D10/5/2017$100.00
      901D11/14/2017$100.00
      901D11/19/2017$105.00

       

      In the sample data above, part numbers 345B and 901D would be identified as a part numbers with a "Price Increase" being they have increased. Part number 678C would be "price decrease". The remaining can be identified as "no price change"