SOLVED

New Contributor

# 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.

Thank you.

5 Replies
best response confirmed by Ellisa2255 (New Contributor)
Solution

# Re: Extract Minimum Value excluding zero in EXCEL

If that's data model table the measure could be

``min Price:=CALCULATE(MIN(Table1[Price] ), Table1[Price] > 0 )``

# Re: Extract Minimum Value excluding zero in EXCEL

Thank you very much.

You are welcome

# Re: Extract Minimum Value excluding zero in EXCEL

Good Afternoon
How would I go about extracting data from sheet 1 to sheet 2 if cell value greater than 0
I'm trying to create a weekly price list (Sheet 2) of available (>0) items from a master list (Sheet 1).

 ID # Name Grade Description Size Cost Price Available OG Bounce Mushroom ULT Original bounce 2” \$25.00 \$32.50 1 OG Bounce Mushroom ULT Original bounce 1” \$16.00 \$20.80 0 OG Bounce Mushroom ULT Original bounce ½" \$12.00 \$15.60 4 Spiderman Bounce Mushroom ULT Blue mushroom w/ bright red/ orange bubbles 2” \$35 \$45.50 0 Spiderman Bounce Mushroom ULT Blue mushroom w/ bright red/ orange bubbles 1” \$26 \$33.80 0

# Re: Extract Minimum Value excluding zero in EXCEL

Depends on your Excel platform / version and what are you going to do with extracted data. As variant that could be FILTER function (microsoft.com)