Merge two table by month in Power query

[sailepaty]

Is there a way two merge two tables by month to obtain the expected output table?

Balances table:				Manager table:				Expected output table
Loc	Jan	Feb	Mar		Loc	Jan	Feb	Mar		Manager	Jan	Feb	Mar
6	23,939	4,552	14,490		6	John	Paul	Paul		John	59,769	35,604	47,973
4	6,842	9,357	3,205		4	Mike	Paul	Paul		Mike	31,737	33,373	4,709
12	15,573	24,154	6,361		12	John	Paul	John		Paul	27,802	71,560	59,115
18	16,770	7,518	5,832		18	John	Paul	John
10	4,620	24,296	5,496		10	Mike	John	John
20	18,436	10,809	18,284		20	Mike	Mike	Paul
2	3,487	23,680	22,728		2	John	Paul	John
15	17,599	11,308	4,709		15	Paul	John	Mike
9	1,839	2,299	23,136		9	Mike	Paul	Paul
3	10,203	22,564	7,556		3	Paul	Mike	John

<tbody>
</tbody>

Thanks

 

[ImkeF]

Yes, of course:

First you unpivot both tables, then join/merge? (sorry about the translaterion, use localized version) via Loc and UnpivotAttribute (month).
Then group by Manager and UnpivotAttribute: Sum on Amount (just ignore Loc here).
Pivot again on months - there you are

 

[sailepaty]

Great, that will work.

Thanks