Forum Discussion
Create the relationship between tables
twister8889 - So, couple ways to do this. Not sure where your many-to-many is though or what is causing it in the data. But yes, combo keys are a good, tried and true method but I always build them like this:
Key = [Column1] & "-" & [Column2] & "-" & [Column3]I put the separators in to avoid clashes like:
9 999 matching 99 99 for example.
First of all, thank you for your answer...
-OK, I will create this key, but It's possible to transform the key to number by these three columns? (Month Department Team) as 1?
-Its better use concatenate & "-" or can I use Merge Columns?
About the many-to-many, I will validate but is between table 1 and table 4Thank you.
Hi twister8889 ,
There are a few documents about data model. You could reference them to optimize your model.
Understand star schema and the importance for Power BI
Many-to-many relationship guidance
Bi-directional relationship guidance
Relationship troubleshooting guidance
