Query Table Autofill Issue

[jsds13]

I have built a couple of SQL queries that pull directly into a table using the Power Query feature in Excel 2013. I added a couple of non-queried columns to my table (a couple of VLOOKUP formulas and a Week of column). The problem is that when my query runs, my formulas don't autofill for the new data. I have to go in and pull the formulas down to the new rows every time the query runs which, as you can imagine, is less than ideal.

So my question is this: is there a setting somewhere that makes it so that when I run the query my non-query formulas will autofill down to the new rows?

Thanks for the help.

[jsds13]

Bumping. No response.

[FDibbins]

Can you do the calcs in the source data, then just pull that into the PT?

[jsds13]

Unfortunately not. A) I don't know enough about SQL yet to do that and B) the VLOOKUP is using tables that are only in Excel. Unless I'm misunderstanding what you mean, I don't think that's possible.