Forum Discussion
Create the relationship between tables
Hi guys, I would like to create a relationship between some tables with common fields (Department, Team, Month) these are my filters. Currently, my relationship is many to many because I have dup...
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 4
Thank 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