How does the SIGN function (DAX) work?
The SIGN function (DAX) returns the sign of a given number.
SIGN Formula Syntax
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
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.