SIGN Function (DAX)

How does the SIGN function (DAX) work?

The SIGN function (DAX) returns the sign of a given number.

SIGN Formula Syntax

SIGN(
     <number>
)

How do you use the SIGN function?

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

Related Support Forum Posts

How to sign up to the forum for Enterprise DNA Membership holders
Data Bars in Table Visualizations – Significant Viz Update in Power BI
How to filter column with values that are IN and that are Not in another column of same table

Considerations when using the SIGN function

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

Formula examples using the SIGN function

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

= SIGN(EmployeeSales[Service Grade])

= SIGN (-55) returns -1.

Related Course Modules

Ultimate-Beginners-Guide-To-PowerBI

DOWNLOAD

To access our comprehensive DAX formula reference guide just insert your email address below. The resource will download immediately and we’ll also email it to you.