Forum Discussion

LuisRossa's avatar
LuisRossa
Regular Visitor
6 years ago

New column: copying existing column with formula and only paste values

Hi, How can I, using power query, copy a column with a formula and paste the results in another column as values? Something similar is done in Excel by copy and paste values Thanks
Need Help
dax's avatar
dax
Icon for Community Support rankCommunity Support
6 years ago

Hi LuisRossa , 

You could refer to Anonymous 's suggestion, if this is not what you want, please correct me and inform more detailed information(such as your expected output and your sample data (by OneDrive for Business))? Then I will help you more correctly.

Please do mask sensitive data before uploading.

Thanks for your understanding and support.
Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

LuisRossa's avatar
LuisRossa
Regular Visitor
6 years ago

Hi All,

 

Thank you for your replies but I'm still stuck.

Let me explain in another way what is I want.

 

I have a column with an ID and a second column with a value, let's call it Status.

Example : xyz,100

Now I can create a conditional column with the formula if [Status] = 100 then 0 else 1.

 

So far, so good ...

 

Now comes what I don´t know how to do it.

 

I want to create a fourth column that copies the contents of the Status column but in  way that it's contents remain static.

 

Example:

 

First run:

xyz,100, 0, 0

 

Second run:

xyz, 200, 1, 0

 

The third column, the one with the formula recalculated, but the last column kept the same value of the previous run.

 

Thanks in advance.