If LIKE in PowerQuery

[Vanessa250919]

Hello I try to have a flag column in M . 

I neef to use IF LIKE 

example 

IF columun 1 like %Parcels%, 'PARCELS' other null 

It's possible ? 

[amitchandak · Accepted solution]

@Vanessa250919 , Try like

if Text.Contains([columun 1], "Parcels") then "PARCELS"

refer

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