Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

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!