Forum Discussion
multiply columns by one column
Hi All I need to transform a bunch of columns by multiplying them on row level by values in a column: Ex in tabel below I need to multiply Column2, Column3 & Column4 by Column1 Column1 Co...
Sorted it out my self, this worked.
Table.FromRecords(Table.TransformRows(#"Changed Type", (x) => Record.TransformFields(x, List.Transform({"Column2", "Column3", "Column4"}, (y) => {y, each x[Column1] * _}))))
Sorted it out my self, this worked.
Table.FromRecords(Table.TransformRows(#"Changed Type", (x) => Record.TransformFields(x, List.Transform({"Column2", "Column3", "Column4"}, (y) => {y, each x[Column1] * _}))))