How to add values in two tables to form a single tables

[Anonymous]

Hello

I am looking to add values in two similar tables and arrive into a single table...explored few otions but not able to get the desired output. if someone have an idea to solve or a solution if you have came across please do let me know how to arrive to this..in Power Bi Desktop..

Input

So we have a sales by person A in the following table

and sales by person B in this table

Output

and we need to arrive at the final i.e. total sales done by both A& B in a single table with the following output

[amitchandak · Accepted solution]

@Anonymous , In power query, add a column in both tables to have sales person's name.

Unpivot both tables have months on rows and append them

https://radacad.com/pivot-and-unpivot-with-power-bi
Append : https://radacad.com/append-vs-merge-in-power-bi-and-power-query