Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
@alolomm Did you tried "Append Queries" option available in "Power Query Editor" ?
Proud to be a PBI Community Champion
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
@alolomm Did you tried "Append Queries" option available in "Power Query Editor" ?
Proud to be a PBI Community Champion
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
97 | |
79 | |
73 | |
56 |
User | Count |
---|---|
145 | |
105 | |
104 | |
90 | |
63 |