Modeling power bi

[Anonymous]

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 :

[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

[Anonymous]

@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. 

[amitchandak]

@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

[Anonymous]

@amitchandak you mean like this : 

And how can I do it also for the relation between Projets and Calendar?

[PaulDBrown]

@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.