Add new column by multiplying column with specific row value

[Anonymous]

I need to do a multiplication from column PRICE and multiply with value from second row from column RATE as table below:

Really appreciate any help on how to do it in power query.

[wdx223_Daniel · Accepted solution]

NewStep=Table.AddColumn(PreviousStepName,"NewCol",each [PRICE]*PreviousStepName[RATE]{1})