Forum Discussion

HungryPowerBIer's avatar
HungryPowerBIer
Frequent Visitor
7 years ago
Solved

Minimum across 2 columns

Hello everyone! I'm in a bit of a quandry and I'm not sure where to start. I need to compare two columns of data, taking the lowest from one column and ignoring the rest. Sample data:    Column ...
Need Help
  • v-yulgu-msft's avatar
    v-yulgu-msft
    7 years ago

    Hi HungryPowerBIer,

     

    Create below calculated column:

    Column3 =
IF (
    Table1[Column 2]
        = CALCULATE ( MIN ( Table1[Column 2] ), ALLEXCEPT ( Table1, Table1[Column 1] ) ),
    Table1[Column 2],
    BLANK ()
)

    Best regards,

    Yuliana Gu

v-yulgu-msft's avatar
v-yulgu-msft
Microsoft Employee
7 years ago

Hi HungryPowerBIer,

 

Create below calculated column:

Column3 =
IF (
    Table1[Column 2]
        = CALCULATE ( MIN ( Table1[Column 2] ), ALLEXCEPT ( Table1, Table1[Column 1] ) ),
    Table1[Column 2],
    BLANK ()
)

Best regards,

Yuliana Gu

HungryPowerBIer's avatar
HungryPowerBIer
Frequent Visitor
7 years ago

v-yulgu-msft thanks so much this did work and I did mark it as a solution! Can I ask how ALLExcept here helps limit this to column 1?