CODEWITHSUNDEEP
powerbipowerquerypowerbi-desktop
variable
variable

Reputation: 9736

How to perform multi-column joins in Power BI?

I have 2 tables in Power query editor.

The relationship between both is based on 3 columns.

However, the merge allows me to only join based on 1 column.

What is the way to perform merge based on 3 column? For example - append the 3 columns into 1 and then merge?

Upvotes: 1

Views: 1504

Answers (1)

davidebacci
davidebacci

Reputation: 30344

You can do multi column joins in power query. Just hold control key and click each column that should be part of the join.

Upvotes: 2

Related Questions