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
If all have true then TRUE
But, Is there any easy way to do it in DAX ?
Go to 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
View solution in original post
NewColumn = Table1[Column1]=Table1[Column2] && Table1[Column1]=Table1[Column3] && Table1[Column2]=Table1[Column3]
Learn how to create your own user groups today!
Click here to read more about the November 2021 Updates!
Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.