Forum Discussion
Power query in excel: add new column whenever source gets updated
Hey guys,
so i have thos power query, that uses an online source. This source contains one column that gets update every month. The data in this column gets overwritten, no new column is added.
In my Excel sheet however, I want my query to add a new column everytime the data source-column gets updated. Tha Columns of the last month should be named after that very month.
Is this possible ?
Thanks in advance,
Nic
2 Replies
- MattAllington
Community Champion
There is no persistent storage in Power Query, but you can use the technique I describe here as a work around. https://exceleratorbi.com.au/keeping-track-of-changes-on-a-website-power-bi/
I think you should use macro in excel.
One way, for instance, could be this: load each month (the output of you query) in a differente sheet of your workbook and, using formulas or VBA, summarise this data in a table stored somewhere.
A peraphs simpler to implement way: get via VAB the data of each mount and store as value in table adding a new column each time.
