Forum Discussion
Modeling power bi
Super UserAnonymous , You need to avoid many to many join. Create some common dimesions and do that. Is it possible ?
https://www.seerinteractive.com/blog/join-many-many-power-bi/
https://radacad.com/many-to-one-or-many-to-many-the-cardinality-of-power-bi-relationship-demystified
amitchandak you mean like this :
And how can I do it also for the relation between Projets and Calendar?
PaulDBrownCommunity Champion
Anonymous
Is the relationship between Consultants and Projets a date field?
It looks to me that the Consultants table filters the Date column in the Projets table (either directly or indirectly) which creates a conflict with the calendar table.
I suggest you create the relationship between the calendar table and the consultants table (instead of Calendar -> projets)
- amitchandak
Anonymous , I need to understand about three tables I mentioned above. can you share some samples so I can understand their relationship and suggested what is needed.