cancel
Showing results for
Did you mean: Frequent Visitor

## 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 ?

1 ACCEPTED SOLUTION  Microsoft

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 2  Microsoft

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  Community Champion

@spaturu3234

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

Lima - Peru   