DAX Function Guide

EVEN
Empty image or helper icon

Sam McKay

CEO & Founder

How does the EVEN work?
The EVEN function (DAX) returns number rounded up to the nearest even integer.
EVEN Formula Syntax

EVEN(
     number
)

How do you use the EVEN?

You can use this function for processing items that come in twos. For example, a packing crate accepts rows of one or two items. The crate is full when the number of items, rounded up to the nearest two, matches the crate’s capacity.

Related Blog Posts

Loading

Considerations when using the EVEN?

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

Regardless of the sign of number, a value is rounded up when adjusted away from zero. If number is an even integer, no rounding occurs.

Related Video Tutorials

Loading

Formula examples using the EVEN

=EVEN(1.5)

=EVEN(3)

=EVEN(2)

Related Courses

Loading