Forum Discussion
Solved
Inactive Relationship
Hi All, I have below tables which has active and inactive relationship assigned, Highlighted Relation is an inactive relationship between dim date and timeentry start date. I am doing a compariso...
Ashish9201 , Many to Many bi- directional indexes are creating loops, so relationships are not valid and inactive. Please correct the model using bridge tables
https://www.seerinteractive.com/blog/join-many-many-power-bi/
Hi amitchandak ,
Let me explain the relationship of tables here, hope this can help you in resolving my difficulty
1 relation is inactive between "Dates" Many to many (table 1 and 2)
2 relation is inactive between "Projects" Many to many (table 1 and 2)
3 relation is active between "Resources" Many to many (table 1 and 2)
4 relation is active between "Dates" Many to one (table 2 and 3)
5 relation is inactive between "Dates" Many to one (table 1 and 3)