Forum Discussion
alolomm
7 years agoRegular Visitor
merging sales from different sources
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
2 Replies
- PattemManohar
Community Champion
- AnonymousNot applicable
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