bridge

[powerbiexpert22]

what is easiest way to create bridge table (for resolving many to many relationship) in less number of steps

[audreygerred · Accepted solution]

There are many ways you could create a bridge table. To do it directly in Power BI, you can open Power Query and duplicate whatever table you have that is more granular than you need it to be, then add in a GroupBy where you can click on advance and select all of the columns that you want to be in your bridge table.