Forum Discussion
Compare Names between tables
Hello All, I have 2 tables with Names of People. Table 1 Name John Max Marry Hilton Mark Chris Leo Table 2 Name John Max Lee Daniel Oleg Swetha both of the tables contai...
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.
amitchandak
Super User
Super UserAnonymous , a new table like
except(Table1[Name], Table2[Name])