Forum Discussion
If - Then - without Else
If you are doing this in Power Query and creating a Custom Column, then you are checking an existing column to check the email address. If you don't find the text you are searching for, the else can just output this unmodified column - for example
if Text.Contains([Email_Address] , "@watersport.com") then "Water for Sport" else [Email_Address]Phil
I'm not sure I understand fully. You can perhaps do something like:
= if Text.Contains([emailaddress], "@watersport") then "Water for Sport" else [emailaddress]
Please mark the question solved when done and consider giving a thumbs up if posts are helpful.
Contact me privately for support with any larger-scale BI needs, tutoring, etc.
Cheers
If you are doing this in Power Query and creating a Custom Column, then you are checking an existing column to check the email address. If you don't find the text you are searching for, the else can just output this unmodified column - for example
if Text.Contains([Email_Address] , "@watersport.com") then "Water for Sport" else [Email_Address]
Phil
Thank you very much, it worked perfectly!