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]
Click here to read more about the December 2021 Updates!
Mark your calendars and join us for our next Power BI Dev Camp!
Learn how to create your own user groups today!