Number.Abs Function of Power Query

The Number.Abs function in Power Query returns the absolute value of a number. If number is null, Number.Abs returns null.

Syntax

Number.Abs(number as nullable number) as nullable number

The function has the following parameter:

number: A number for which the absolute value is to be calculated.

Example: Transform the 'Sales' column to absolute values.

Power Query M

let
    // Step 1: Define sample data
    Source = Table.FromRecords({
        [ID=1, Sales=-100],
        [ID=2, Sales=200],
        [ID=3, Sales=-50],
        [ID=4, Sales=300]
    }),

    // Step 2: Transform 'Sales' column to absolute values
    Converted = Table.TransformColumns(Source, {{"Sales", each Number.Abs(_), type number}})
in
    Converted

The output of the above code is shown below:

Previous Next