Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I was given a table and two columns on the table have a many to many relationship. I know that I can create two new tables and create the relationships between them and the original table. But I would like to know Powerbi Desktop can allow me to create a many-to-many relationship between two columns in the same table. This would be a straight and simplest solution.
Solved! Go to Solution.
HI @Curious1_209,
AFAIK, current power bi does not support multiple active relationship keys between two tables. (power bi will use one major relationship to mapping and analysis table records, the others will turn to inactive)
Did you mean the standalone many to many relationships on two columns or the combo relationship based on multiple fields?
If you mean the second one, you can take a look at the following link to know how to create relationships based on multiple fields.
Relationship in Power BI with Multiple Columns - RADACAD
Regards,
Xiaoxin Sheng
HI @Curious1_209,
AFAIK, current power bi does not support multiple active relationship keys between two tables. (power bi will use one major relationship to mapping and analysis table records, the others will turn to inactive)
Did you mean the standalone many to many relationships on two columns or the combo relationship based on multiple fields?
If you mean the second one, you can take a look at the following link to know how to create relationships based on multiple fields.
Relationship in Power BI with Multiple Columns - RADACAD
Regards,
Xiaoxin Sheng
Separating these columns out into their own dimension tables seems to be the right approach here. Hard to tell without sample data and more context.
"straight and simple" and "many to many" do not go well together.
User | Count |
---|---|
93 | |
84 | |
78 | |
75 | |
66 |
User | Count |
---|---|
115 | |
105 | |
93 | |
65 | |
60 |