Vanessa250919Helper V5 years agoSolvedIf LIKE in PowerQuery 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 ? Show Moreamitchandak5 years agoVanessa250919 , Try like if Text.Contains([columun 1], "Parcels") then "PARCELS" refer https://docs.microsoft.com/en-us/powerquery-m/text-contains
amitchandak5 years agoVanessa250919 , Try like if Text.Contains([columun 1], "Parcels") then "PARCELS" refer https://docs.microsoft.com/en-us/powerquery-m/text-contains
amitchandak5 years agoVanessa250919 , Try like if Text.Contains([columun 1], "Parcels") then "PARCELS" refer https://docs.microsoft.com/en-us/powerquery-m/text-contains
amitchandakSuper User5 years agoVanessa250919 , Try like if Text.Contains([columun 1], "Parcels") then "PARCELS" refer https://docs.microsoft.com/en-us/powerquery-m/text-contains
Related contentPowerQuery transformationETL Options with files loop (powerquery or free?)Powerquery table refresh time[PowerQuery] add (same) column from another tablePowerQuery merge issue
