Forum Discussion
Modeling power bi
Hello,
I'm working on a model on a power bi desktop, and I'm modeling these tables below :
So as you can see in this model the relationship between the table Relevé de temps et consultants is not active and they are connected with the field identifiant.
Also, the relationship between the table Projets et calendar is not active and they are connected with the field Date.
So how can I change this relationship to be an active relationship? Any tips? I tried to change it directly as is shown below but it didn't work :
6 Replies
- amitchandak
Super User
Anonymous , 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 , Consultant is One; in one join and many on another join.
Can you provide some more information on project , consultant and Relevé de temps, what kind of data
amitchandak the data that we are working on projects contains the code of projects that we are working on and they are related to a time record (relevès de temps) indirectly with code project by the intermediate of the table Table.
