Forum Discussion
Lowest Price
Hello All, I am trying to get a calculation that will give me the lowest price by item. I have a list of items that can be listed multiple times with all different prices. I want each record to c...
Hi Anonymous ,
You can try creating the below measure -
Lowest price = CALCULATE(MIN(Current Price),ALLEXCEPT(Table,Item))
Hope this helps!Please accept the solution if this answers your query.
Thanks!
Avantika
Avantika-Thakur
Solution Supplier
Solution SupplierHi Anonymous ,
You can try creating the below measure -
Lowest price = CALCULATE(MIN(Current Price),ALLEXCEPT(Table,Item))
Hope this helps!
Please accept the solution if this answers your query.
Thanks!
Avantika
Thank you, this worked! Would you be able to tell me the measure I should use to calculate the difference between the two? Current price minus the lowest price found. I'm trying with just a quick measure but that forces it to be a sum or a count.