Forum Discussion
Solved
Extract Minimum Value excluding zero in EXCEL
| Brand | Model | Price |
| Toyota | Corolla | 0 |
| BMW | E24 | 100,000 |
| Toyota | Camry | 120,000 |
| Toyota | Yaris | 80,000 |
Good day. Kindly assist...
I have an auction sale data set similar to the one above. I am using excel 2013 and I want to extract the minimum price of the Car Brands excluding zero(s)-using DAX. In that way, for Toyota I can have 80,000 as the minimum price instead of 0.
Your help is much appreciated.
Thank you.
If that's data model table the measure could be
min Price:=CALCULATE(MIN(Table1[Price] ), Table1[Price] > 0 )
5 Replies
If that's data model table the measure could be
min Price:=CALCULATE(MIN(Table1[Price] ), Table1[Price] > 0 )- Thank you very much.
You are welcome
