Forum Discussion
Solved
Append Tables
Hello,
I have 4 separate tables and a calendar date (time intelligence).
I created (append) a new table from the SALES LINES and CREDITS LINES
How do I add the POSTING DATE column to the appended SALES and CREDIT table?
Thanks.
4 Replies
It's a Merge operation in Power Query.
It might be easier to do the 2 merges: invoice with invoice lines, credit with credit lines
and then do the Append
It will depend on whether your data is all in good shape ,for example, do all the Invoice Lines have a related Invoice. Let's hope that they do. If they do, then Inner Join.
The documentation here has some neat Venn diagrams that explain it.
https://learn.microsoft.com/en-us/power-query/merge-queries-inner
