Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
Hi,
i need to cut die the domain from an e-mail columns, i tryed the command:
Domain1 = LEFT(Tabelle1[Column1];FIND("@";Tabelle1[Column1]-1))
And iam wondering that i have two diffrent Error Codes.
How can i fixed this?
Thanks
Solved! Go to Solution.
Hi,
You can do this so much easier via the Query Editor and use the split column transformation and split by @
BR
Erik
@ThoSch then you can use the last parameter of FIND function - NotFoundValue and set it to 1. If you want blank, when there is no @ in email. If you want the text, then insert IF function as well.
Regars.
Pavel
Hi,
You can do this so much easier via the Query Editor and use the split column transformation and split by @
BR
Erik
Thanks, the solution is working fine for me.
Hi @ThoSch. Subtracting by 1 should be after FIND function. DAX should be as:
Domain1 = LEFT(Tabelle1[Column1];FIND("@";Tabelle1[Column1])-1)
Regards.
Pavel
thanks, that solved one problem, but if there is empty field, i have the other error.
@ThoSch then you can use the last parameter of FIND function - NotFoundValue and set it to 1. If you want blank, when there is no @ in email. If you want the text, then insert IF function as well.
Regars.
Pavel
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
56 | |
54 | |
54 | |
37 | |
29 |
User | Count |
---|---|
77 | |
63 | |
45 | |
40 | |
40 |