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

 

Struggling here

DAX

2 Replies

  • 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?