Lookup value

Hi,

As per your requirement, there is a sample table with Work Email, Source 1, and Source 2 as shown in the below screenshot.

In order to get result 1 to get the work emails does not match from Source 1 we can create a new table with the below DAX expression:

Result1 = FILTER('Emails Table', not('Emails Table'[Work Email] = 'Emails Table'[Source1]))

This will create a new table with work emails that do not match with emails from Source 1 column. Please refer to the below screenshot.

Similarly, for Result 2 we can use the DAX expression as follows which results in emails, which does not match from Source 2 column.

If this answer helps, please mark it as Accepted Solution so it would help others to find the solution.

Thanks!

Inogic Professional Services

An expert technical extension for your techno-functional business needs

Power Platform/Dynamics 365 CRM

Drop an email at [email protected]

Service:  http://www.inogic.com/services/  

Power Platform/Dynamics 365 CRM Tips and Tricks:  http://www.inogic.com/blog/