Why my AND and NOT operator with Text.Contains in multiple if having problems?

[Anonymous]

Hi all,

I am not sure why my power Query M below kept getting error on 

if Text.Contains([User status], "CANC") and Text.Contains([System status], "CLSD) then "Non-Compliant"
else if not (Text.Contains([User status], "CANC")) and Text.Contains([System status], "CLSD") then "Complaint"
else if Text.Contains([System status], "TECO") then "Compliant"
else "Non-Complaint"

See following screenshot.

[jdbuchanan71]

I think you are missing a closing quote.

[suryaburaboyina · Accepted solution]

Hi,

"" double qoutes are missing. "CLSD"

Please correct and try.

Thanks,

Surya teja