Is it possible to create a many-to-many relationship between two columns in the same table?

[Curious1_209]

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.

[Anonymous · Accepted 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

[lbendlin]

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.