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
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 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 tableThank you this is the same solution I have come up with as well which will work for most instances.
Housden996 , You're welcome!