Forum Discussion

rjsidek's avatar
rjsidek
Helper II
6 years ago
Solved

Creating a 1-Many Relationship

Hi everyone,   I have a master table with an identifier which is the company name. I know that in my data model there will be multiple tables, so I would need to establish a realtionship. That said...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    HI rjsidek ,

    You can consider using union, distinct, values functions to create a calculated table to extract and combine distinct value from original tables and use it as a bridge table to link the table with 'one to many' relationships.

    Bridge =
DISTINCT ( UNION ( VALUES ( Table1[Column1] ), VALUES ( Table2[Column1] ) ) )

    If above not work, can you please share some dummy data for test?

    How to Get Your Question Answered Quickly 

    Regards,

    Xiaoxin Sheng

Anonymous's avatar
Anonymous
Not applicable
6 years ago

HI rjsidek ,

You can consider using union, distinct, values functions to create a calculated table to extract and combine distinct value from original tables and use it as a bridge table to link the table with 'one to many' relationships.

Bridge =
DISTINCT ( UNION ( VALUES ( Table1[Column1] ), VALUES ( Table2[Column1] ) ) )

If above not work, can you please share some dummy data for test?

How to Get Your Question Answered Quickly 

Regards,

Xiaoxin Sheng

rjsidek's avatar
rjsidek
Helper II
6 years ago

This did the trick, thank you! but I still find it weird cause I removed duplicates but still did not have all distinct values, which is weird