ODD Function (DAX)

How does the ODD function (DAX) work?

The ODD function (DAX) returns number rounded up to the nearest odd integer.

ODD Formula Syntax

ODD(
     number
)

How do you use the ODD function?

An odd integer.

Related Blog Posts

Related Support Forum Posts

Understanding DAX Formula
Developing Complex Dax functions

Considerations when using the ODD function

If number is nonnumeric, ODD returns the #VALUE! error value.

Regardless of the number sign, when set away from zero, a value is rounded up. If number is an odd integer, no rounding takes place.

Related Video Tutorials

Formula examples using the ODD function

= ODD (1.5) returns 3.

Rounds 1.5 up to the nearest odd integer.

= ODD (3) returns 3.

Rounds 3 up to the nearest odd integer.

= ODD (2) returns 3.

Rounds 2 up to the nearest odd integer.

= ODD (-1) returns -1.

Rounds -1 up to the nearest odd integer.

= ODD (-2) returns -3.

Rounds -2 up (away from 0) to the nearest odd integer.

Related DAX Functions

Related Course Modules

Ultimate-Beginners-Guide-To-PowerBI
Center of Excellence

DOWNLOAD


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
Membership