Forum Discussion

spaturu3234's avatar
spaturu3234
Frequent Visitor
9 years ago
Solved

How can I compare three columns in DAX

I Have three calculated columns X,Y,Z   I need to compare X=Y=Z and flag them if they are not equal    I can do by creating a three different columns agian  like X=Y Y=Z X=Z   If all have tr...
Need Help
  • v-huizhn-msft's avatar
    v-huizhn-msft
    9 years ago

    Hi spaturu3234,

    You just need to create a calculated column using the formula.

    Flag = IF(Table4[Column1]=Table4[Column2]&&Table4[Column2]=Table4[Column3]&&Table4[Column1]=Table4[Column3],"True","False")


    I create a sample table and test it, please see the result below.



    Best Regards,
    Angelia

v-huizhn-msft's avatar
v-huizhn-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

Hi spaturu3234,

You just need to create a calculated column using the formula.

Flag = IF(Table4[Column1]=Table4[Column2]&&Table4[Column2]=Table4[Column3]&&Table4[Column1]=Table4[Column3],"True","False")


I create a sample table and test it, please see the result below.



Best Regards,
Angelia