cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
OzzieFrog Member
Member

Cannot apply operator & to types Logical and Text

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

1 ACCEPTED SOLUTION

Accepted Solutions
Stachu Super Contributor
Super Contributor

Re: Cannot apply operator & to types Logical and Text

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

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

Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

View solution in original post

2 REPLIES 2
Stachu Super Contributor
Super Contributor

Re: Cannot apply operator & to types Logical and Text

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

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

Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

View solution in original post

OzzieFrog Member
Member

Re: Cannot apply operator & to types Logical and Text

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

Helpful resources

Announcements
New Kudos Received Badges Coming

New Kudos Received Badges Coming

Kudos to you if you earned one of these! Check your inbox for a notification.

Microsoft Implementation for Communities Wins Award

Microsoft Implementation for Communities Wins Award

Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Kudoed Authors (Last 30 Days)
Users online (2,256)