Forum Discussion
Relating tables with repeated fields
I don't get it, what the Problem is but here is something that might help with the Relationships.
Go to Modeling Tab and Create new Table based on Distinct Values so that there are no Repeated Values
Table = DISTINCT(TableName[ColumnName])
Then Create Relationship of other Tables with this one,
Go to Home Tab and Manage Relationships to Edit or Create Relationships
Select Table Name and Manager Column Name in both Tables
Also, Cross Filter Direction should be Both
I don't get it, what the Problem is but here is something that might help with the Relationships.
Go to Modeling Tab and Create new Table based on Distinct Values so that there are no Repeated Values
Table = DISTINCT(TableName[ColumnName])
Then Create Relationship of other Tables with this one,
Go to Home Tab and Manage Relationships to Edit or Create Relationships
Select Table Name and Manager Column Name in both Tables
Also, Cross Filter Direction should be Both
Thanks for your reply, I will test it out. For better understanding, this is what my unrelated tables look like before:
So what has to be related is the customer ID.
When I let Excel power query relate it, the result looks like this:
I am not sure whether I could use such data in a senseful way in Power BI, because I'm used to other BI software.
So i tried your solution, creating new tables and creating relationships with this one works perfect, but there's no change in my data when I select after a field, that appears in both tables and is connected as you mentioned.
Maybe see my example above for further ideas, as I have no clue whether the solution is the right one for my problem. Thank you anyway!
Still not sure what u doing but it worked on mine.
Table A and B are joined using Sales Manager and not the Customer.
Once u do that click on Relationship Manager and do Auto Detect.
It worked meanwhile with my data. The problem was, that there were some uncertain values by which the dates could not be connected. Thanks for the help!
