Table of contents
Collapse the table of content
Expand the table of content

SIGN Function (DAX)

Owen Duncan|Last Updated: 10/5/2018
1 Contributor

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.




numberAny 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.

Return ValueDescription
1The number is positive
0The number is zero
-1The 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]) )  

See Also

Math and Trig Functions (DAX)

© 2018 Microsoft