Forum Discussion
Use a result query as a table for the next iteration [Solved]
Hello everybody,
I'm trying to use Power query and Excel as a kind of Database, maybe it's not the good solution, but I would like your advice.
As my english isn't the best, I made a small drauwn to explain :
I would like to be able to use a result query as the main query the next month, so I can recursively add data each month : The Yellow arrow is my problem I guess !
Thank you for your help
Pierre
PS unable to use the drag and drop function to add a xlsx file ... sorry for that
Hello,
I found a easy way to answer my problem :
- Create a "connexion only" on first Table (AAA)
- Create a connexion on the second Table (BBB), make your modification (Append ...), Save and Publish in the Workbook
- At this step, you should have a new Table named BBB_2, for example
- Delete the entire Table BBB
- Rename the Table BBB_2 => BBB
- That's all folks
It works for me, thank you for your help everybody
7 Replies
- AntrikshSharma
Community Champion
Anonymous It is doable with List.Accumulate, you can post the data on google drive and create a shareable link.
- AntrikshSharma
Anonymous If there is no way to tell the month from the data then the file should have some indication, otherwise how will you define logic?
Hello,
I found a easy way to answer my problem :
- Create a "connexion only" on first Table (AAA)
- Create a connexion on the second Table (BBB), make your modification (Append ...), Save and Publish in the Workbook
- At this step, you should have a new Table named BBB_2, for example
- Delete the entire Table BBB
- Rename the Table BBB_2 => BBB
- That's all folks
It works for me, thank you for your help everybody
Anonymous could you use a blank query and just append each month in?
Fake Data tables
Start with blank query then append each month/table and it'll keep growing
let
Source = #table(null,{}),
#"Appended Query" = Table.Combine({Source, #"Jan Data", #"Feb Data"})
in
#"Appended Query"Think that gives the result you are after?
Thanks,
