DAX Function Guide

ODD
Empty image or helper icon

Sam McKay

CEO & Founder

How does the ODD 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?

An odd integer.

Related Blog Posts

Loading

Considerations when using the ODD?

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

Loading

Formula examples using the ODD

= 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 Courses

Loading