Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

DAX Formula If Statement

I have a table Merge1.   Two columns im looking at: compliance_status and S1 Installed   I need to have a calulated column that if compliance_status has the value Action Needed and S1 Installed h...
DAX
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

Anonymous , You can create a new column

 

power query

if [compliance_status] = "Action Needed" and [S1 Installed] = "Not Installed" then "Not compliant" else  "Compliant"

 

dax

 

if ([compliance_status] = "Action Needed"  && [S1 Installed] = "Not Installed" ,"Not compliant" ,"Compliant")

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    for some reason it is still not acting as needed. maybe because it is merged table - should i mention the table name or?