Convert negative numbers to positive

Power Query
2

Hi @Mario

You can use Table.TransformColumns and Number.Abs for that. Nice thing is you don’t even have to write any M code to implement that step. Just select the column, go to

  1. Transform on the Ribbon
  2. Select Scientific and then Absolute Value

And this code will be created for you:

Table.TransformColumns(
    #"Your previous step name here",
    {{"sales_qty", Number.Abs, Int64.Type}}
)

All done :wink:

2 Likes