Update values from another table

h_gp9
Posts: 23
Joined: Wed Jan 18, 2017 9:50 am

Update values from another table

Postby h_gp9 » Tue Sep 05, 2017 10:10 am

Good day to all dear member:

I have two sheet in the same worbook: "New Price" & "Previous Price"
I need to replace new price instead previous price according with column headers common between both (Material Number, PO Price, etc)
After this update, I need to recalculate column [Total Actual] with this formula → ([PO Price] + [Freight]) * [Usage].
How do I get this only for items that are changing and without include or add more columns?
I was trying with Record.FromTable but I'm new with M code.
Could you please help me?

Thanks in advanced
Attachments
PRECIO.xlsx
(342.77 KiB) Downloaded 12 times

User avatar
AndVGri
Posts: 31
Joined: Thu Jun 02, 2016 2:41 am
Location: Sankt-Peterburg

Re: Update values from another table

Postby AndVGri » Tue Sep 05, 2017 8:48 pm

Hi
You could use a such solution for updating with join by key new and previous price tables.
Regards,

h_gp9
Posts: 23
Joined: Wed Jan 18, 2017 9:50 am

Re: Update values from another table

Postby h_gp9 » Thu Sep 07, 2017 12:52 am

Very sorry I don't understand your suggest.
Could you kindly send me a real code that include numbers?

Thanks


Return to “Power Query”

Who is online

Users browsing this forum: No registered users and 1 guest