Forum Discussion
Post ProdigyPutting together data from 2 companies
aha, if the table column headers are the same, it would be easy to stitch (called append in PQ) them in Power Query.
In your case, you may need
1) to add a Company column, say Company1 in table1 and Company2 in table2, both named "Company", check this:
https://learn.microsoft.com/en-us/power-query/add-custom-column
2) Append the two tables, check this:
https://learn.microsoft.com/en-us/power-query/append-queries
Super Userhi Oros
the most similar would be like this:
the dataset:
the point is: the value fields (profit/sales in your case) could be plotted in Matrix Visual like columns but not like rows.
OrosHI FreemanZ ,
Thank you very much for your reply. Sorry if my post is not clear. What I would like to achieve is to 'merge' the 2 separate companies tables. Let's say that each table has the same columns as date, sales, products, customers, salespersons. Please note that these 2 companies have the same salespersons but NOT the same products and customers. Thanks again
- FreemanZ
aha, if the table column headers are the same, it would be easy to stitch (called append in PQ) them in Power Query.
In your case, you may need
1) to add a Company column, say Company1 in table1 and Company2 in table2, both named "Company", check this:
https://learn.microsoft.com/en-us/power-query/add-custom-column
2) Append the two tables, check this:
https://learn.microsoft.com/en-us/power-query/append-queries