Forum Discussion
Power Query data refresh and assign previous comments dynamically.
Hi,
I am Power query beginner and really looking for some advice.
I haveworkbook with two tables- one is loaded power query and 2nd is the table with checking results and formulas. I am trying to think about the way to automatically move my comments stored in the table with formulas on the data refresh in power query table, for example when I add/ remove data these rows from 2nd table are not moving up/down- making comments useless. Formulas as such are okay as they reference the data from loaded power query table dynamically, just the comments that I input manually in the 2nd table are not moving.
Could you guide me what I could do to make them comments moving alongside the data in power query table?
Thanks!
Anonymous read this Matt Allington's article about self referencing tables in Power Query.
1 Reply
- AlienSx
Super User
Anonymous read this Matt Allington's article about self referencing tables in Power Query.