DAX Formula If Statement

[chrisdavila]

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 has Not Installed then it will say Not compliant if else Compliant.

Struggling here

[amitchandak]

@chrisdavila , 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")

[chrisdavila]

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