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?
Bookmarks