Custom Column error

[Anonymous]

Hi i am trying to run this simple query to isolate a colum based on a string in my column using the following formula :

if "  | medtigo" in [Page Title] then Null  else [Page Title]

This line of code is giving me Token then expected error.

[amitchandak · Accepted solution]

@Anonymous , text-contains  or =

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

Try like

if Text.Contains([Page Title]," | medtigo") then Null else [Page Title]

if "  | medtigo" =  [Page Title] then Null  else [Page Title]

Please provide your feedback comments and advice for new videos
Tutorial Series Dax Vs SQL Direct Query PBI Tips
Appreciate your Kudos.