Forum Discussion
Keep the added column intact when updating the new data
lyly1203 Google for "self referencing tables power query" and you'll find many sites that deal with this. The main principle is that you connect to a data source (call it source 1). Do the necessary transformations and load it back to Excel. Let's say this table is then called PQ_output, Add your own column(s) expanding that table. Now, change the original query and add a second source (call it source 2) that connects to the PQ_output table that now includes the extra columns and merge it with source 1 within the same query.
A simple example is demonstrated in the link below.
https://exceleratorbi.com.au/self-referencing-tables-power-query/
lyly1203 Google for "self referencing tables power query" and you'll find many sites that deal with this. The main principle is that you connect to a data source (call it source 1). Do the necessary transformations and load it back to Excel. Let's say this table is then called PQ_output, Add your own column(s) expanding that table. Now, change the original query and add a second source (call it source 2) that connects to the PQ_output table that now includes the extra columns and merge it with source 1 within the same query.
A simple example is demonstrated in the link below.
https://exceleratorbi.com.au/self-referencing-tables-power-query/
