The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
Is there a function or statement that will convert an email address to the domain? test@gmail.com to gmail.com?
Solved! Go to Solution.
If you are using DAX :
Domain = RIGHT([Email], LEN([Email]) - SEARCH("@", [Email]))
If you are using PQ :
Text.AfterDelimiter([Email], "@")
If you are using DAX :
Domain = RIGHT([Email], LEN([Email]) - SEARCH("@", [Email]))
If you are using PQ :
Text.AfterDelimiter([Email], "@")