Power Query - want to add formulas to query output

I have 2 sets of big data that I am merging together using Power Query.

After the merge I have a worksheet that contains the full set of data in a table.

I would like to add about 20 or 30 calculated columns to the end of the merged table, but at this stage I don't want these fields calculated within Power Query (the calculations are very complicated and are already in place).

I can add a calculated column to the new table (using a good old fashioned excel formula), but when I refresh the merge query I lose the calculated field.

Is there a way I have the best of both worlds, merge my data and include all my calculated columns together?

That's what I currently do too. Be nice to have it all it one place.

That's different to what I see, the entire column disappears on Refresh.

Office Pro Plus 2013

But amazingly when I tick the box the new column stays and is updated with the query!!!

So far so good, also found other useful checkboxes in that spot to enable formatting and cell formatting to stay.