Can we match one column from one table to other table?

[bourne2000]

Hi

I have below two tables

	Table 1
Name	Email	School
Kate	kate@abc.com	abc
Smith	smith@abc.com	abc
John	john@abc.com	abc

	Table 2
Name	Email	School
Kates	kates@abc.com	abc
Smith jo	smithjo@abc.com	abc
John	john@abc.com	abc

I want to check if the name column of Table 2 is present in Table 1. We can see different names are present in table 1.

Kates, Smith jo is not available in Table 1, hence I need to print these records in the different table.

I need output as below

	Output
Name	Email	School
Kates	kates@abc.com	abc
Smith jo	smithjo@abc.com	abc

Both tables don't have any relationship. If I try to connect both the tables, it's coming many to many relationships. Can anyone please advise. I tried vlookup but no success.

[Ashish_Mathur]

Hi,

I have solved it using the Query Editor.  You may download my PBI file from here.

Hope this helps.

[Jihwan_Kim · Accepted solution]

Hi, @bourne2000 

Please check the below picture and the formula for creating a new table.

Output Table =
SUMMARIZECOLUMNS (
Table2[Name],
Table2[Email],
Table2[School],
FILTER ( Table2, NOT ( Table2[Name] IN VALUES ( Table1[Name] ) ) )
)

https://www.dropbox.com/s/xqcq4seqgypia8i/bournev2.pbix?dl=0 

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

Linkedin: linkedin.com/in/jihwankim1975/

Twitter: twitter.com/Jihwan_JHKIM