I've run into this problem with a couple different projects and want to know what's the best way to accomplish. I want to pull data from various online sources and generate a table, I can do this much. The problem being if I then add formulas directly into the cells in a new column they either erase or get overwritten by the current calculated value, I understand why this is happening. I want the formulas to stay "live" and update when data changes, not have to refresh constantly. I know I can put them in a separate table but I don't always know how many rows power query is going to pull or when I do refresh the data because more items were added to the sources. I do not have access to the source data. Do I do the oversize the table trick and hope the source never exceeds the size I pick? Hard code formulas into pq and refresh constantly? Pull data into a raw table and manually copy and create an input table every time I do need to refresh?(how I've been doing it) Please advise and help.