Lesser of Two Values

[reportuser]

Column A	Column B	Desired Value = Lesser value from A or B
14	16	14
19	12	12
0	0	0

I need to make a column or a measure that picks the lowest value and also needs to account for 0.

[v-yangliu-msft · Accepted solution]

Hi  @reportuser ,

Here are the steps you can follow：

1. Create measure.

Measure =
var _column1=MAX('Table'[Column A])
var _column2=MAX('Table'[Column B])
return
IF(
    _column1>_column2,
    _column2,
    _column1
)

2. Result:

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[amitchandak]

@reportuser ,

New column = Min([Column A], [Column B])