Compare two tables' data in power BI

[SBC]

Hi,

I have two tables, we neeed to compare two tables data matching between two tables and not matching data them in power bi .

User should able to understand the match data between two  tables and not matching data  in single table visual in power bi.

Table1:

Table2:

Note: in model part when we connect two table we can do only many-many relationship.

Does any one have worked on such kind of scenario?

Thanks,

SBC 

[SBC · Accepted solution]

Hi  ,

above requirement get fullfilled by using full outer join and applying conditional column in the power query.

for reference please go through below links:

Link1: Solved: Re: Compare columns based on two different table - Microsoft Power BI Community

link2: 15.4 Merge Data Having Multiple Criteria or Multiple Columns in Power BI (Power Query) - YouT...

Thanks,

SBC

[Waldo35]

I am not sure i understand the question entirely, but i hope i did otherwise you can let me know. 

My table 1

My table2

hereby making profit number on row 4 different.

Then the table which looks for non matching rows:

In this case keeping the profit_number of table2. But of course if not needed you could take table1.

Formula

= Table.RemoveMatchingRows(Table2, Table.ToRecords( Table1))