Cannot apply operator & to types Logical and Text

[OzzieFrog]

Hi folks,

I have obviously been staring at this for too long and am too tired, so can I please ask for your assistance to identify why I'm getting the "we cannot apply operator & to types Logical and Text" to the following formula:

if Text.Contains([Location_Name],"WP") = true & Text.Clean([Job_Title]) = "Associate" then "Associate" else if Text.Contains([Location_Name],"WP") = true & Text.Clean([Job_Title]) = "Process Control" & Text.Contains([Union],"AU") then "Process Controller" else if Text.Contains([Location_Name],"WP") = true & Text.Clean([Job_Title]) = "Process Control" & Text.Contains([Union],"CF") then "Power Station Controller" else [Job_Title]

 Thanks in advance.

OF

[Stachu · Accepted solution]

'&' is concatenate, I think you need 'and'

https://docs.microsoft.com/en-us/powerquery-m/operators

[OzzieFrog]

@Stachuyou were right, thank you very much. I was obviously too out of it to even pick it up 🙂