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
Examples
-- ABS returns the absolute value of a number
-- SIGN returns:
-- +1 if the number is positive
-- 0 if the number is zero
-- -1 if the number is negative
DEFINE
VAR Vals = GENERATESERIES ( -2, +2, 0.5 )
EVALUATE
ADDCOLUMNS (
Vals,
"ABS", ABS ( [Value] ),
"SIGN", SIGN ( [Value] )
)
ORDER BY [Value] DESC
| Value | ABS | SIGN |
|---|---|---|
| 2.00 | 2.00 | 1 |
| 1.50 | 1.50 | 1 |
| 1.00 | 1.00 | 1 |
| 0.50 | 0.50 | 1 |
| 0.00 | 0.00 | 0 |
| -0.50 | 0.50 | -1 |
| -1.00 | 1.00 | -1 |
| -1.50 | 1.50 | -1 |
| -2.00 | 2.00 | -1 |
Last update: Jul 24, 2021 » Contribute » Show contributors
Contributors: Alberto Ferrari, Marco Russo
Microsoft documentation: https://docs.microsoft.com/en-us/dax/sign-function-dax
2018-2021 © SQLBI. All rights are reserved. Information coming from Microsoft documentation is property of Microsoft Corp. » Contact us » Privacy Policy & Cookies