5 Replies Latest reply on Aug 25, 2016 9:56 AM by Andrew Watson

    Calculate the difference between min and maximum values

    Prasenjeet Acharjee

      I have a situation. I want to calculate the difference between min value of price and maximum value of price for each product id for each month. Price is just one column. I have duplicated price measure and calculated min and max price from the duplicates. But i am not able to figure out how can i calculate the difference between min and max price for each product id for each month (Context: The price of a product id varies during a month)

       

      Please help.