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
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!