Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 :
@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.
@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?
@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)
Proud to be a Super User!
Paul on Linkedin.
@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.
User | Count |
---|---|
90 | |
73 | |
68 | |
63 | |
56 |
User | Count |
---|---|
103 | |
94 | |
74 | |
60 | |
59 |