How can I compare three columns in DAX

[spaturu3234]

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 ?

[v-huizhn-msft · Accepted solution]

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]

@spaturu3234

NewColumn = Table1[Column1]=Table1[Column2] && Table1[Column1]=Table1[Column3] && Table1[Column2]=Table1[Column3]