Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

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_Daniel's avatar
    wdx223_Daniel
    Community Champion

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