link similar columns

[Thomas897]

Hello everyone,

I would like to join 3 similar columns on 2 different tables (in my case: country, month and company). Unfortunately, Power BI tells me that it is not possible because those columns do not have unique values. I tried to append these columns and erase duplicates, it works for one column but for the others I cannot join them to both tables because it could create a confusion for Power BI.

I am stuck for 2 days on this matter, I have watched 10 videos at least, but it does not work.

Thank you for answering me.

[chethan · Accepted solution]

Hey @Thomas897

concatenate all the 3 coloums & Create the Unique Id so that it will be easy to creat the joins

[Salvador]

Hello Thomas,

I would create a table in excel, with unique values (such as the company, or country), then add it to the dataset, and establish relations between both tables and the new one, and enable filtering in both ways.

If that doesnt work for you, I'd appreciate a sample dataset, and what you would like to achieve 🙂

Regards,

Salvador.

[Thomas897]

I am sorry, I am not fluent in English and it is too hard for me to explain my problem but I would like to know if a DAX formula could do the job.

Thanks

[Salvador]

Hi,

You could also create unique identificators. It would depend on what you would want to achieve.

For example, you could use Concatenate() with country, month and company, to create a unique identificator, and be able to establish relationships between both tables.