Forum Discussion
Trouble Creating Relationships
HI all, I've tried the solutions that I've found in previous tickets but it still won't work for me. Everytime I want to create a relationship between the different sql tables I get the error...
Anonymous,
You may add a new table and build relationship on the concatenated column.
Table = ADDCOLUMNS ( DISTINCT ( 'Name&group' ), "Name | Group", 'Name&group'[Name] & " | " & 'Name&group'[Group] )
Hey,,
I’ve read your article about creating relationships, tried again with the things I’vee read but still I’m ,ot able to create a good relationship.
regards
Do you have a single column in the name and group table that has unique values? It doesn't look like it.