Forum Discussion

IEG's avatar
IEG
Frequent Visitor
4 years ago
Solved

DAX If statement

Hi,   I have two data sets, I want to compare 2 different column values and bring the higher value. i have done this with measure but I want to create a new column which contains higher values of t...
Need Help
  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    4 years ago

    Hi, IEG ;

    You could create a new column by following:

    Column = var _mman=MAX([MANQty])
var _mshp=MAX([ShpQty])
return IF(_mman<_mshp,[ShpQty],[MANQty])

    The final output is shown below:

    Best Regards,
    Community Support Team_ Yalan Wu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-yalanwu-msft's avatar
v-yalanwu-msft
Community Support
4 years ago

Hi, IEG ;

You could create a new column by following:

Column = var _mman=MAX([MANQty])
var _mshp=MAX([ShpQty])
return IF(_mman<_mshp,[ShpQty],[MANQty])

The final output is shown below:

Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

IEG's avatar
IEG
Frequent Visitor
4 years ago

Thank you, that worked