Join tables in Power bi

[Anonymous]

Hi, 

Im trying to join two data tables in Power bi.  Unfortunately the tables will not join as I received the error :

"You cant create a relationship between these two columns because one of the columns must have unique values"

So I attempted to create unique Key columns that are concatenations of several columns in each of the tables where there is similar data.  Still getting the error and so cannot form a relationship.  Do the columns in each table holding similar data need to share the same name? In extracting the data in the key columns to see if there are duplicates, there are members that repeat, so I guess they are not unique.  How can that be done? What am I missing here?  Is there a different approach to getting tables to join or create a third table from the contents of the first two?  Appreciate any insight.  Thanks.

[amitchandak]

@Anonymous , You might be trying to create a one-to-many join, that will cause an issue.

You can create a combined column using combinevalues and use that for join

Key = combinevalues("-", [Col1], [Col2])

if two are facts, then you should create dim, and do no join them

Power BI- DAX: When I asked you to create common tables: https://youtu.be/a2CrqCA9geM
https://medium.com/@amitchandak/power-bi-when-i-asked-you-to-create-common-tables-a-quick-dax-solution-8e3eccb41bda