invalid relationship for tables that should be many-to-one

[Anonymous]

Hi there,

I am trying to concenate two columns from two different tables. One column (assume table "A") is the week of year and another one is working place in the factory. What I would like to do, is connect the table with working place in the factory which has unique values with the column in table "A" that uses the same values but they are repeated. Hence, I assume I want to have many-to-one relationship.

Thank you for the inputs.

[v-shex-msft · Accepted solution]

HI @Anonymous ,

You can consider to create a calculated table to extract unique value from these table and use it as bridge table to link two tables.

Regards,

Xiaoxin Sheng