Forum Discussion
multiply columns by one column, problem with data type changing
Hi All I am transforming a bunch of columns by multiplying them on row level by values in a column: Ex in tabel below I multiply Column2, Column3 & Column4 by Column1 (all columns 1-4 are data...
Hi Anonymous ,
You could use the Table.TransformColumnTypes function to change all the data types to decimal number.
= let output=Table.FromRecords(Table.TransformRows(#"Changed Type", (x) => Record.TransformFields(x, List.Transform({"Column2", "Column3", "Column4"}, (y) => {y, each x[Column1] * _})))) in Table.TransformColumnTypes(output,List.Transform(Table.ColumnNames(output), each {_, type number}))Table.TransformColumnTypes - PowerQuery M | Microsoft Learn
List.Transform - PowerQuery M | Microsoft Learn
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous ,
You could use the Table.TransformColumnTypes function to change all the data types to decimal number.
= let
output=Table.FromRecords(Table.TransformRows(#"Changed Type", (x) => Record.TransformFields(x, List.Transform({"Column2", "Column3", "Column4"}, (y) => {y, each x[Column1] * _}))))
in
Table.TransformColumnTypes(output,List.Transform(Table.ColumnNames(output), each {_, type number}))
Table.TransformColumnTypes - PowerQuery M | Microsoft Learn
List.Transform - PowerQuery M | Microsoft Learn
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.