Forum Discussion
Impactful Individualmanytomany
Hi powerbiexpert22 ,
please refer below video to create the bridge table :
https://www.youtube.com/watch?v=urTwxelK-Xc
Thanks,
Ankita
Impactful IndividualHi anmolmalviya05 , how to create bridge table with two columns as shown in example i gave?
Hi powerbiexpert22 ,
I create two tables and you can see both of them have ProductID column.
If only the ProductIDs in these two tables are linked, there will be warnings and Many-to-Many will easily cause the model to report errors.
Which can be solved by using bridge tables. Then I create a bridge table.
You end up with two one-to-many joins of two tables that just had a many-to-many relationship via the ProductID column in the bridge table.
Best Regards
Yilong Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- powerbiexpert22
Hi Anonymous ,
how did you create bridge table?
- AnkitaaMishra
Super User
Hi powerbiexpert22 ,
please refer below video to create the bridge table :
https://www.youtube.com/watch?v=urTwxelK-Xc
Thanks,
Ankita Hi powerbiexpert22 ,
A bridge table is something you create yourself, as its name suggests, a manually created table by means of a column that exists in both tables at the same time.
Best Regards
Yilong Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.