How extract column field from another table and insert into 1 st table

Have you considered using a formula instead of a Power Query.
See the example below:

However, it can also be accomplished using Power Query.

Good Luck 🙂

At first glance, it doesn't appear to be correct.

Assume you have a table named: Sales that contains the columns: DateOfSale and OrderNumber

If you want to return the DateOfSale for OrderNumber = "12345", your Dax LookUpValue function would be:

LookUpValue('Sales'[DateOfSale],'Sales'[OrderNumber],"12345")

Good Luck!