DAX Math & Trigonometric - EVEN function


Advertisements

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

Useful Video Courses


Video

Mastering DAX and Data Models in Power BI Desktop

53 Lectures 5.5 hours

Abhay Gadiya

Video

Mastering DAX Studio

Featured

24 Lectures 2 hours

Randy Minder

Video

DAX / Power BI - Customer and Sales Analysis Deep Dive

26 Lectures 4.5 hours

Randy Minder

Advertisements