Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
venstart
Frequent Visitor

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

venstart_0-1613904191486.png

 

Please help

Regards

shabeer

4 REPLIES 4
Jimmy801
Community Champion
Community Champion

Hello @venstart 

 

you can right-click on your column and choose "duplicate column"

Jimmy801_0-1613928401860.png
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

 

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.

Hello @venstart 

 

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

 

BR

 

Jimmy

stevedep
Memorable Member
Memorable Member

AdditionCol = Table.Addcolumn(#"Renamed Columns", each [Total Value])

in 

AdditionCol

 

Please go to the advanced editor and add the above code.

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors
Top Kudoed Authors