EVEN DAX Function (Math and Trig)
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.
Syntax
| Parameter | Attributes | Description |
|---|---|---|
| Number |
The value to round. |
Return values
Returns number rounded up to the nearest even integer.
Remarks
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 functions
Other related functions are:
Last update: Dec 1, 2018 » Contribute » Show contributors
Contributors: Alberto Ferrari, Marco Russo
MSDN documentation: https://msdn.microsoft.com/en-us/query-bi/dax/even-function-dax