Forum Discussion
How to format a Dynamic Contains String to Exclude
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 splittingStep 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
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!