Forum Discussion
Solved
multiply several columns by another column using M
I have a table that looks like this: quantity Salary EBP OH 1 68 20 25 7 73 21 27 0.5 80 25 30 I want to multiply each of the Salary, EBP and OH columns by Quantity...
=Table.ReplaceValue(#"Source",each [quantity],"",(x,y,z)=>x*y,{"Salary","EBP","OH"})
=Table.ReplaceValue(#"Source",each [quantity],"",(x,y,z)=>x*y,{"Salary","EBP","OH"})