We're giving away 30 tickets for FREE! Share your story, your vision, or your hustle and tell us why YOU deserve a ticket.
Apply nowWin a FREE 3 Day Ticket to FabCon Vienna. Apply now
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], "@")
User | Count |
---|---|
67 | |
61 | |
47 | |
35 | |
32 |
User | Count |
---|---|
87 | |
72 | |
56 | |
49 | |
45 |