SIGN DAX Function (Math and Trig)
Returns the sign of a number: 1 if the number is positive, zero if the number is zero, or -1 if the number is negative.
Syntax
SIGN ( <Number> )
| Parameter | Attributes | Description |
|---|---|---|
| Number |
Any real number. |
Return values
Scalar A single integer value.
The possible results are:
- 1 if the number is positive
- 0 if the number is zero
- -1 if the number is negative
Last update: Feb 6, 2019 » Contribute » Show contributors
Contributors: Alberto Ferrari, Marco Russo
MSDN documentation: https://msdn.microsoft.com/en-us/query-bi/dax/sign-function-dax