Forum Discussion
Using PowerQuery to move and store records being generated in one table to a "Master" Table
I have developed a file that allows a user to choose a project from a list and then input forecasted expenses into a box.
The file only allows for one project to be forecasted at a time; once the user inputs the expense, rows are created using formulas.
These forecast rows are combined with budget & actual data with the help of PowerQuery to create a pivot table.
I am having trouble creating a method using PowerQuery to move the formula generated rows (residing in table #1) into table #2, where table #2 can then be updated/refreshed in order to capture new rows from table #1 from the various projects the user inputs expense for.
I apologize if the description of the scenario isn't clear; also thank you for the help in advance.
Hi fraljones ,
if my understanding is correct, this should do the job: https://www.thebiccountant.com/2016/02/09/how-to-create-a-load-history-or-load-log-in-power-query-or-power-bi/
7 Replies
Not sure if I understand, but have you tried the append function in Power Query using new table to join the two tables together in a third table, and then delete uneeded columns? Maybe you can give us examples?
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
NathanielNathaniel_C I updated the below chart to better explain my problem:
As mentioned in the chart, I am having difficulties trying to figure out how to:
1. Send new records from Table #1 to Table #2
2. Keep all old data in Table #2
Thank you for your help Nathaniel.
Ok, going off line, but will be thinking about that and get back to you tomorrow. Clear and concise explanation.
Nathaniel
