How to compare 2 columns from 2 table with Many to Many Relation Ship

[Anonymous]

Hello Experts,

Seeking your Tricks on to How to compare 2 columns from 2 different Tables which is having Many to Many relationship and the resultant table to show what are Matching and Not Matching in one Single Table.

Sample Data:

Output/Resultant Table:

Item No

Line No

Order No

Table A Request Date

Table B Request Date

Request Date Match vs Not Match

Table A Qty

Table B Qty

Qty Match vs Not Match

[Anonymous]

Hi @v-stephen-msft ,

Relationship is created by Concatenated column of (OrderNo-ItemNo-LineNo) in both the tables.

[v-stephen-msft]

Hi @Anonymous ,

There can only be one active relationship between two tables, please tell me which fields are the active relationship.

You may kindly refer to the similar post if it can help you:

Solved: Comparing two table columns which is having Many t... - Microsoft Power BI Community

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.