Compare Names between tables

Hi Anonymous

What is your expected output in the table visual? If you only want to know which names only exist in Table 1 and which names only exist in Table 2, we just need to compare name values in Name column of each table and don't need to use other columns. 

One idea is to add a column in each table to mark "Yes" if a name is only in this table and "No" if it's in the other table too. You can use this column to filter visuals later. 

Only in Table 1 = IF('Table 1'[Name] IN VALUES('Table 2'[Name]),"No","Yes")


Only in Table 2 = IF('Table 2'[Name] IN VALUES('Table 1'[Name]),"No","Yes")

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.