Store Power Query table and add calculated field

[jaryszek]

Hi,

can i add formula to custom column for PQ but formula to workbook sheet, not to PQ columns?

I mean when you added PQ table, you can add new column manually to it with for example vlookup. But when you will refresh table you will lost your calculation.
How can you add this in PQ? Or automate in other way?

Best,
Jacek

[AliGW]

What is the calculation you want to do?

[jaryszek]

Hi AliGW,

thank you. Sorry i think that this is wrong approach.
I should do all calculations in PQ and output table into Excel then. Another approach is wrongly from beginning.

I am closing topic.
Best,
Jacek