Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

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...
Need Help
  • v-chuncz-msft's avatar
    v-chuncz-msft
    8 years ago

    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]
)
Anonymous's avatar
Anonymous
Not applicable
8 years ago

I can't access the file that you've created to have a look at it, sorry!

Anonymous's avatar
Anonymous
Not applicable
8 years ago

if you add an concatenated colum how did you do it?

And removing the duplicate names in my names&groups table, wouldn't dit result in an loss of data?

 

Some names are indeed 3 or more times in the name&group table but it's because they also appear in different groups.

 

Pfff really stuck on this