Forum Discussion
Solved
Convert Email to Domain
Is there a function or statement that will convert an email address to the domain? [email protected] to gmail.com?
If you are using DAX :
Domain = RIGHT([Email], LEN([Email]) - SEARCH("@", [Email]))If you are using PQ :
Text.AfterDelimiter([Email], "@")
1 Reply
If you are using DAX :
Domain = RIGHT([Email], LEN([Email]) - SEARCH("@", [Email]))If you are using PQ :
Text.AfterDelimiter([Email], "@")