Forum Discussion
i_luv_data88
3 years agoNew Member
Many-to-many relationship using a bridge table?
Hello, I have the following data model: a dimensional table that links to the fact table using the "Marketing ID" field. The problem is the "Marketing ID" field in the dimensional table is not unique...
amitchandak
Super User
3 years agoi_luv_data88 , Create common/bridge Tables like
Power BI- Power Query: When I asked you to create common tables: https://youtu.be/PqfGW6pl1Sw
Power BI- DAX: When I asked you to create common tables: https://youtu.be/a2CrqCA9geM
https://medium.com/@amitchandak/power-bi-when-i-asked-you-to-create-common-tables-a-quick-dax-solution-8e3eccb41bda