Number.Sign

The function Number.Sign returns different values based on the input number: 1 indicates a positive number, -1 indicates a negative number, and 0 indicates zero. If the input number is null, the function will also return null.

Identify the sign of a number by using the Power Query M function Number.Sign. When the function is applied to the number 182, the output will be 1, indicating a positive sign. Conversely, when the function is applied to -182, the output will be -1, indicating a negative sign. Lastly, when the function is applied to 0, the output will be 0, indicating a neutral sign.