Hits: 2353
If you want to perform calculations in Power Query, usually you have to add a new column and delete the original one. In this short blog entry, I’ll show you a way to perform in column calculations.
Typical way
Given is a table as follows:
We just want to multiply each value by 10. To achieve this, usually we would add a new column:
= Table.AddColumn(chType, "new Column", each [Amount]*10)
and end up with this:
Then we would delete the original column and rename the new one to “Amount”…….
In column calculations
A more effective way would be to perform “in column calculations”.
All we have to do is to write this little function:
=Table.FromRecords(
Table.TransformRows(chType,
(in_place) =>
Record.TransformFields(in_place,
{"Amount", each in_place[Amount] * 10}))
)
The function transforms each row of the column “Amount” and multiplies the value with 10 – in place!
That’s all. No need to delete a column!
Do you want to learn more about Power BI or Power Query?
Take a look here.
Happy Querying!
