RELTIONSHIPS

[MoumouhElRebeld]

Hi

Can you explain to me when i need to use a MANY to MANY relation or a 1 to MANY relation ?

Thank you

[Idrissshatila]

Hello,

You could take this free course from SQLBI to learn more about data modeling that includes the relationships one to mny and many to many.
https://www.sqlbi.com/p/introduction-to-data-modeling-for-power-bi-video-course/

If I answered your question, please mark my post as solution so it would appeare to others, Appreciate your Kudos 👍

Follow me on Linkedin

[MoumouhElRebeld]

Thank you

[TomasAndersson · Accepted solution]

Hi!
A one to many relationship between a dimension and fact table are usually considered best practice. Many to many relationships can sometimes be used to remove the need for a creating a dimension table with unique values, but should generally be avoided when possible.

You can read more about relationships here: Back to Basics: Power BI Relationship Demystified - RADACAD
And about one-to-many vs many-to-many here: Many-to-One or Many-to-Many? The Cardinality of Power BI Relationship Demystified - RADACAD

[MoumouhElRebeld]

Cristal clear

Thank you