merging sales from different sources

[alolomm]

Hello 

i have my total sales from feb 2017 till this date 2018 on  my sql server. 

i also have my sales from jan 2017 only in excel. 

im trying to merger the total sales fileds from the diferent tables ( sql & excel) [adding jan 2017 sales from excel to 2017 sales] where my primamry key would be the sales man name since the sales people exists in both tables. 

what is the best way to combines the total sales taking into consideration the dates from 2017 and 2018

thanks alot 

[Anonymous]

It sounds like you want to append the two tables together?

Have a look at this post, I think you should find a suitable solution here:

https://community.powerbi.com/t5/Desktop/Append-two-tables-with-different-sizes/td-p/135153

[PattemManohar · Accepted solution]

@alolomm Did you tried "Append Queries" option available in "Power Query Editor" ?