Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
I have an exchange inbox imported to my PowerBI report and I want to group the different email domains to reflect the same category.
For example
Recieved emails:
XXXX@123.com
- 3 emails
YXYX@123.com
- 4 emails
XYXY@456.com
- 2 emails
Desired result:
@Anonymous.com
- 7 emails
@456.com
- 2 emails
Is there any way to do this?
Solved! Go to Solution.
However, Does this require more manual input as new email addresses are added? - No, you need not to. You have to define the Column from Example once, and if you are satisfied with the output then any new record will be updated accordingly.
Is there anyway to automate it? I'm thinking something like a statement that trims down and removes characters before the @ character.
Alternatively, you could do this in two steps:
Cheers!
Vivek
If it helps, please mark it as a solution
Kudos would be a cherry on the top 🙂
https://www.vivran.in/
Connect on LinkedIn
Hello @ARag ,
You may use following steps in Power Query:
Cheers!
Vivek
If it helps, please mark it as a solution
Kudos would be a cherry on the top 🙂
https://www.vivran.in/
Connect on LinkedIn
Hi @vivran22
Seems to work! However, Does this require more manual input as new email addresses are added?
Is there anyway to automate it? I'm thinking something like a statement that trims down and removes characters before the @ character.
However, Does this require more manual input as new email addresses are added? - No, you need not to. You have to define the Column from Example once, and if you are satisfied with the output then any new record will be updated accordingly.
Is there anyway to automate it? I'm thinking something like a statement that trims down and removes characters before the @ character.
Alternatively, you could do this in two steps:
Cheers!
Vivek
If it helps, please mark it as a solution
Kudos would be a cherry on the top 🙂
https://www.vivran.in/
Connect on LinkedIn
User | Count |
---|---|
47 | |
26 | |
21 | |
17 | |
15 |
User | Count |
---|---|
53 | |
34 | |
17 | |
17 | |
15 |