SIGN DAX Function (Math and Trig)

Syntax  |  Return values  

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: Nov 20, 2020   » Contribute   » Show contributors

Contributors: Alberto Ferrari, Marco Russo

MSDN documentation: https://docs.microsoft.com/en-us/dax/sign-function-dax