SIGN Function (DAX)

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




Download our comprehensive DAX Formula Reference Guide as perfect companion as you learn how to use DAX formulas within Power BI.

Download DAX Formulas Reference Guide
Download DAX Formula Reference Guide