DAX Math & Trigonometric - EVEN function



Description

Returns the number rounded up to the nearest even integer.

DAX EVEN function is new in Excel 2016.

Syntax

EVEN (<number>) 

Parameters

Sr.No. Parameter & Description
1

number

The number value to round.

Return Value

Number rounded up to the nearest even integer.

Remarks

You can use this function for processing items that come in twos.

Example

= EVEN (3) returns 4. 
= EVEN (2.25) returns 4. 
= EVEN (2.55) returns 4. 
= EVEN (-2.55) returns -4. 
= EVEN (-2.25) returns -4. 
dax_functions_mathematical_trigonometric.htm
Advertisements