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

tex628's avatar
tex628
Community Champion
6 years ago

First make sure that there are no duplicates in your distinct table:

Select the data-view:


Select the correct table and column, at the bottom left of the screen the following information should be displayed:


As you can se here my lndex column that is selected has the same amount of distinct values as the total number of rows in the table. This means that the column is completly unique. 

Check this and then get back to me! 🙂 

Br,
J

rjsidek's avatar
rjsidek
Helper II
6 years ago

Hi tex628 

 

I checked it, and you were right! It seems that I have 438 rows but only 436 distinct values. I tried to remove dupicates in power query but it is still giving me the same result. Managed to find one of the duplicates, but I cannot for the life of me find the other one. Is there a way to do like conditional formatting to highlight duplicates in powerbi?