Export (0) Print
Expand All

SIGN Function (DAX)

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.


SIGN(<number>)

Term

Definition

number

Any real number, a column that contains numbers, or an expression that evaluates to a 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]) )
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft