Forum Discussion
Anonymous
4 years agoNot applicable
Add new column by multiplying column with specific row value
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.
NewStep=Table.AddColumn(PreviousStepName,"NewCol",each [PRICE]*PreviousStepName[RATE]{1})
1 Reply
- wdx223_DanielCommunity Champion
NewStep=Table.AddColumn(PreviousStepName,"NewCol",each [PRICE]*PreviousStepName[RATE]{1})