Forum Discussion

sjacob's avatar
sjacob
Frequent Visitor
4 years ago
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 lik...
  • latimeria's avatar
    latimeria
    4 years ago

    Add a new column with this Dax code

    Compliant = IF ( 'Table'[Column1] in { "Male", "Female" } , "Compliant" , "Non-Compliant" )
latimeria's avatar
latimeria
Icon for Solution Specialist rankSolution Specialist
4 years ago

Add a new column with this Dax code

Compliant = IF ( 'Table'[Column1] in { "Male", "Female" } , "Compliant" , "Non-Compliant" )