SIGN is a DAX function that returns the sign of a number: 1 if positive, 0 if zero, and -1 if negative.
Syntax
SIGN( Number )| Argument | Properties | Description |
|---|---|---|
| Number | Any real number. |
SIGN
Updated on
SIGN is a DAX function that returns the sign of a number: 1 if positive, 0 if zero, and -1 if negative.
SIGN( Number )| Argument | Properties | Description |
|---|---|---|
| Number | Any real number. |
A whole number. The possible Return values are 1, 0, and -1.
| Return value | Description |
|---|---|
| 1 | The number is positive |
| 0 | The number is zero |
| -1 | The number is negative |
The following formula returns the sign of the result of the expression that calculates sale price minus cost.
= SIGN( ([Sale Price] - [Cost]) )
2023-2024 © BI Gorilla. All rights are reserved. Information from Microsoft docs is property of Microsoft Corp. | Privacy Policy