Forum Discussion
Power Query Editor copy value to new column
Hi There
So I have a table called : Stock Database
Within this table there is a column (field) called : Total Value
Now this field a calculated field from sharepoint online list (the data source)
Now what i on Power Query Editor, to copy the values from Total Value to a new column (field) within this same table. However the copy process must be a step process so that its dynamic on each refreshing of this table. Now, since this field "Total Value" a calculated fields from sharepoint online list, so the copy must should be like a Excel, special Paste value to only copy the value and not the formula.
The new custom column called should be called: TValue
Below a screenshot current table and field
Please help
Regards
shabeer
4 Replies
- Jimmy801Community Champion
Hello venstart
you can right-click on your column and choose "duplicate column"
If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
Kudoes are nice too
Have fun
Jimmy- venstartFrequent Visitor
Hi Jimmy801
Thank you for your reply, however if I duplicate this field.
Will it refresh and bring new data changes if a specifix value has changed with the Total Value field. Remember the Total Value field on sharepoint is a calculated field, so from time to time the total value will change since the user will edit the quanity or stock purchased so that the Total Value will update automatically.
- stevedepMemorable Member
AdditionCol = Table.Addcolumn(#"Renamed Columns", each [Total Value])
in
AdditionCol
Please go to the advanced editor and add the above code.