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

Announcements

#### 2022 Release Wave 1 Plan

Power Platform release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.