Forum Discussion
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 true then TRUE
But, Is there any easy way to do it in DAX ?
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
2 Replies
v-huizhn-msftMicrosoft Employee
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- Vvelarde
Community Champion
NewColumn = Table1[Column1]=Table1[Column2] && Table1[Column1]=Table1[Column3] && Table1[Column2]=Table1[Column3]
