Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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.
Solved! Go to Solution.
NewStep=Table.AddColumn(PreviousStepName,"NewCol",each [PRICE]*PreviousStepName[RATE]{1})
NewStep=Table.AddColumn(PreviousStepName,"NewCol",each [PRICE]*PreviousStepName[RATE]{1})