How to merge queries in power bi with 2 primary keys

Question

How do we merge two queries in power bi when the primary key is a combination of 2 columns.

for example i have 2 tables

Table A :

year
cost center
col a
col b
col c

Table B:

year
cost center
col x
col y
col z

The primary key in both the columns is a combination of the 1st two columns. How do i merge these two queries?

Answer 1

When you merge the queries using the GUI, you can hold down Ctrl to select multiple columns from each table. (Make sure you select them in the same order on both tables.)