DAX Function Guide

SIGN
Empty image or helper icon

Sam McKay

CEO & Founder

How does the SIGN work?
The SIGN function (DAX) returns the sign of a given number.
SIGN Formula Syntax

SIGN(
     <number>
)

How do you use the SIGN?

The function returns 1 if the number is positive, 0 (zero) if the number is zero, or -1 if the number is negative.

Related Blog Posts

Loading

Considerations when using the SIGN?

If number is greater than zero, the SIGN function will return 1.
If number is equal to zero, the SIGN function will return 0.
If number is less than zero, the SIGN function will return -1.

Related Video Tutorials

Loading

Formula examples using the SIGN

=SIGN( ([Sale Price] – [Cost]) )

= SIGN(EmployeeSales[Service Grade])

= SIGN (-55) returns -1.

Related Courses

Loading