ISEVEN DAX Function (Information)
Returns TRUE if number is even, or FALSE if number is odd.
Syntax
ISEVEN ( <Number> )
| Parameter | Attributes | Description |
|---|---|---|
| Number |
The value to test. If number is not an integer, it is rounded to the nearest integer. |
Return values
Scalar A single boolean value.
Returns TRUE if Number is even, or FALSE if number is odd.
Examples
-- ISEVEN checks that a number is EVEN,
-- ISODD checks that a number is ODD
EVALUATE
{
( "ISEVEN ( 10 )", ISEVEN ( 10 ) ),
( "ISODD ( 10 )", ISODD ( 10 ) ),
( "ISEVEN ( 11 )", ISEVEN ( 11 ) ),
( "ISODD ( 11 )", ISODD ( 11 ) ),
( "ISEVEN ( -3 )", ISEVEN ( -3 ) ),
( "ISODD ( -3 )", ISODD ( -3 ) ),
( "ISEVEN ( -4 )", ISEVEN ( -4 ) ),
( "ISODD ( -4 )", ISODD ( -4 ) )
}
| Value1 | Value2 |
|---|---|
| ISEVEN ( 10 ) | true |
| ISODD ( 10 ) | false |
| ISEVEN ( 11 ) | false |
| ISODD ( 11 ) | true |
| ISEVEN ( -3 ) | false |
| ISODD ( -3 ) | true |
| ISEVEN ( -4 ) | true |
| ISODD ( -4 ) | false |
Related functions
Other related functions are:
Last update: Jul 1, 2025 » Contribute » Show contributors
Contributors: Alberto Ferrari, Marco Russo, Kenneth Barber,
Microsoft documentation: https://docs.microsoft.com/en-us/dax/iseven-function-dax
2018-2025 © SQLBI. All rights are reserved. Information coming from Microsoft documentation is property of Microsoft Corp. » Contact us » Privacy Policy & Cookies