Forum Discussion
Power 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
Hi, bml123 ,
Slicer from Date Table, Table with all fields from Both Tables, relationship like this (Date and ID):
Is this something you want? Also, having Many to Many relationships is always not the best option, ideally if you had one table that has unique IDs. Like this, it's very bad design.
bml123
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.