Forum Discussion
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.
Hi Anonymous
Sorry the two images you attached are the same...
I think my method still works. You just need to add two table visuals on a report page. In the first table visual, put Name from Table 1 into it as Values. Drag Only in Table 1 column to Filters on this visual section in Filter pane and set show items when value is "Yes". Repeat the same operation for the second visual for Table 2.
Tour the report Filters pane - Power BI | Microsoft Docs
BR,
Jing
Thank You, It worked indeed!