Forum Discussion
Solved
Creating Relationship Issue (ambiguity)
Hello, I have three tables DimDate , Ads_Drivilogy2 and Ads_Driviology3 I want to create 3 relationships between these tables 1. Date of Dim Date with Date of Ads_Drivilogy2 2. 1. Date of ...
Create separate table for Campaign then join both tables with this Campaign table.
usmanrafiq , You need to have Campaign as bridge table or common dimension .
refer
https://www.seerinteractive.com/blog/join-many-many-power-bi/
https://radacad.com/power-bi-basics-of-modeling-star-schema-and-how-to-build-it
Create a common/bridge table code -
https://www.dropbox.com/s/op9lb78w9utdonz/Distinct%20from%20two%20Tables.pbix?dl=0