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 the two columns.

Here is an example, If ManQty > ShpQty then it will bring ManQty to the new column else it should bring ShpQty to the new column

Thank you all

Regards

IEG

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.

3 Replies

  • 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