Forum Discussion
Post PatronPower BI relationships between tables
Hi bml123 ,
Between two table,you cannot have more than one active relationship, you have to use userelationship function to use inactive relationship.
Similar case refer:
https://community.powerbi.com/t5/Desktop/Multiple-active-relationships-between-2-Tables/td-p/928298
And you could also rfer the following article:
Use Multiple Connections Between Tables
Did I answer your question? Mark my post as a solution!
Best RegardsLucien
Post Patron
Super Userbml123
Well, you can't create a "circle" between tables, so ideally you create Date Table and map it with Clients Details or Details depends how you wanna use it, like this:
And then map Client and Clients ID together by ID, like this:
However, Many to Many is not the best practice, I strongly suggest creating a Clients Details table, where every ID is unique.