SIGN

SIGN Determines the sign of a number, the result of a calculation, or a value in a column. The function returns 1 if the number is positive, 0 (zero) if the number is zero, or -1 if the number is negative.


Syntax

SIGN(number)

Parameters

Number – Any real number, a column that contains numbers, or an expression that evaluates to a number.

Return Value

A whole number. The possible Return values are 1, 0, and -1.


Reference Data

https://docs.microsoft.com/en-us/dax/dax-function-reference

DAX Functions / Math and Trig Functions / SIGN