Forum Discussion
How to compare 2 columns from 2 table with Many to Many Relation Ship
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 |
2 Replies
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.