Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code FABINSIDER for a $400 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hi
My client wants to exclude emails from a list based on key phrases being stored in a sharepoint list, is this possible.
I am thinking something along the lines of this but there isnt a way to join the two tables are the domain for the emails are all unique:
Solved! Go to Solution.
@Housden996 Thanks for sharing this sample input data. So, here I took the sample for EmailTable and ExcludeTable like this:
Step 1: Go to Transform Data option, Select EmailTable, then select "Email" column and right click and choose "Duplicate Column"
Step 2: Then right click on this above duplicate column and follow the below step for splitting
Step 3: Remove the extra column after splitting
Step 4: Click on Merge as New query option
Step 5: Do the below setting
Step 6: Then save and close.
Step 7: On Table visua;, take ID and email from this Merge1 table
@Housden996 , It would be great if you can share the sample input data along with expected output in order to understand your query.
Thanks for your response.
So the intial data table would look along the lines of:
Then there would be another data source the client has access too where they can add records along the line of:
I would then need some dax to exclude any of the emails which contain said phrases within the table above to return a table such as bellow:
@Housden996 Thanks for sharing this sample input data. So, here I took the sample for EmailTable and ExcludeTable like this:
Step 1: Go to Transform Data option, Select EmailTable, then select "Email" column and right click and choose "Duplicate Column"
Step 2: Then right click on this above duplicate column and follow the below step for splitting
Step 3: Remove the extra column after splitting
Step 4: Click on Merge as New query option
Step 5: Do the below setting
Step 6: Then save and close.
Step 7: On Table visua;, take ID and email from this Merge1 table
Thank you this is the same solution I have come up with as well which will work for most instances.
@Housden996 , You're welcome!
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Check out the February 2025 Power BI update to learn about new features.
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
84 | |
69 | |
68 | |
39 | |
37 |