Jun 06 2022 06:41 AM
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.
Jun 06 2022 10:29 AM
SolutionIf that's data model table the measure could be
min Price:=CALCULATE(MIN(Table1[Price] ), Table1[Price] > 0 )
Jun 18 2022 06:12 PM - edited Jun 18 2022 06:54 PM
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 |
Jun 19 2022 10:16 AM
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)
Jun 06 2022 10:29 AM
SolutionIf that's data model table the measure could be
min Price:=CALCULATE(MIN(Table1[Price] ), Table1[Price] > 0 )