Forum Discussion
Table Relationships based on multiple columns
Is there any way to create a table relationship that correlates 2+ columns instead of 1? I don't have a unique column to join the tables but by comparing multiple columns then the data could be corre...
Hi Anonymous ,
You can combine two columns into one column, join using that column
Go to Power query and find the two columns you need in Table 1 – Merge Columns.
Repeat the first step for Table2.
Then use the merge column to join.
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Anonymous,
You can create a column that concatenates the columns that should be used in the relationship. Then, create a relationship using the concatenated column.