PowerBI -how to join 2 tables and get all unmatchedrecords from tab1 and unmatched records from tab2

[Nandhini07]

Hi, i am trying to join two tables and end result be unmatched records from both tables.Please help with the solution at the earliest. Thanks in advance. 

[MikeBresnan]

Not to Necropost, but you can now do Left/Right Anti join in the query merge menu, and get unmatched rows.

[v-yulgu-msft · Accepted solution]

Hi @Nandhini07,

You can do this in Query Editor mode.

Sample table.

Table1                                                           Table2

         

Merge (Outer Join) these two tables as a new one.

Expand the tableand apply filters.

Result.

Best regards,
Yuliana Gu

[Nandhini07]

Thanks for the solution. will try and let you know.