Forum Discussion
data does not match
Hi, I have a model as uploaded here. https://easyupload.io/t3qpdk When I compare two tables, they do not match. When I tried with even simpler example where there is a list of supplier na...
The typical method of modeling for many to many relationships is to create a bridging table that allows you to place the bridging table in the middle of your current relationship and replace the many to many with a 1 to many relationship between the bridging table and each of your existing tables.
Please see here for more background and guidance: Many-to-many relationship guidance - Power BI | Microsoft Learn
Dale