Forum Discussion
Solved
DAX Command To Mark Compliant/Non Compliant
Hello,
I would like assistance in creating a DAX formula that can mark values from a column as compliant or non-compliant.
For example, if I have the following columns and values, I would like to add a second column, that can mark which values are compliant and non compliant:
Gender DAX Measure Column:
Male Compliant
F Non-Compliant
Female Compliant
F Non-Compliant
(blank) Non-Compliant
Appreciate the assistance.
Regards,
Sajan
Add a new column with this Dax code
Compliant = IF ( 'Table'[Column1] in { "Male", "Female" } , "Compliant" , "Non-Compliant" )
