Forum Discussion
Solved
getting lowest value and highest value
Hi, I need to know how to get the lowest ShippingPrice and the highest ShippingPrice for a ProductID. Thanks ProductID ShippingPrice Lowest Price Highest Price 5 32.38 6 11.61...
Hi iamprajot,
In addition, you can also create measures or calculated columns use ALLEXCEPT Function below:
Lowest Price = CALCULATE(MIN('Table2'[ShippingPrice]),ALLEXCEPT(Table2,'Table2'[ProductID]))
Highest Price = CALCULATE(MAX('Table2'[ShippingPrice]),ALLEXCEPT(Table2,'Table2'[ProductID]))
Best Regards,
Qiuyun Yu
Hi iamprajot,
In addition, you can also create measures or calculated columns use ALLEXCEPT Function below:
Lowest Price = CALCULATE(MIN('Table2'[ShippingPrice]),ALLEXCEPT(Table2,'Table2'[ProductID]))
Highest Price = CALCULATE(MAX('Table2'[ShippingPrice]),ALLEXCEPT(Table2,'Table2'[ProductID]))
Best Regards,
Qiuyun Yu
Much appreciated, thanks.
