EVEN Function (DAX)
Returns number rounded up to the nearest even integer. 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.
EVEN(number)
Parameters
| Term | Definition |
|---|---|
| number | The value to round. |
Returns number rounded up to the nearest even integer.
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.
| Formula | Description | Result |
|---|---|---|
| =EVEN(1.5) | Rounds 1.5 to the nearest even integer | 2 |
| =EVEN(3) | Rounds 3 to the nearest even integer | 4 |
| =EVEN(2) | Rounds 2 to the nearest even integer | 2 |
| =EVEN(-1) | Rounds -1 to the nearest even integer | -2 |
Community Additions
ADD
Show: