Forum Discussion

venstart's avatar
venstart
Frequent Visitor
5 years ago

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 so...
Need Help
Jimmy801's avatar
Jimmy801
Community Champion
5 years ago

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

 

venstart's avatar
venstart
Frequent Visitor
5 years ago

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.

  • Jimmy801's avatar
    Jimmy801
    Community Champion
    5 years ago

    Hello venstart 

     

    yes it should always have the same value as you total value column. Give it a try and give feedback

     

    BR

     

    Jimmy