DAX Information - ISEVEN function



Description

Returns TRUE if the number is even, or FALSE if the number is odd.

DAX ISEVEN function is new in Excel 2016.

Syntax

ISEVEN (<number>) 

Parameters

Sr.No. Parameter & Description
1

number

The numeric value to test.

If the number is not an integer, it is truncated.

Return Value

TRUE or FALSE.

Remarks

If the number is non-numeric, DAX ISEVEN function returns the #VALUE! error.

Example

= ISEVEN (8) returns TRUE. 
= ISEVEN (7) returns FALSE. 
dax_functions_information.htm
Advertisements