ISEVEN FUNCTION not working correctly

[Anonymous]

Hello, 

I am trying to use the "ISEVEN" function to see only even numbers on a column. I don't know the reason it is giving me wrong results (please refer to the picture attached). 

Example

I am using the following formula: 

TESTEVEN  = ISEVEN(ECS_EZQuery40[DEBIT_AMOUNT])

Does anyone know what the issue could be? 

Thanks 

[v-frfei-msft]

Hi @Anonymous ,

To create a calcualted column using INT function.

Column = INT(ECS_EZQuery40[DEBIT_AMOUNT])=ECS_EZQuery40[DEBIT_AMOUNT]

Or we can create a measure as below.

Measure = INT(MAX(ECS_EZQuery40[DEBIT_AMOUNT]))=MAX(ECS_EZQuery40[DEBIT_AMOUNT])

Regards,

Frank

[v-frfei-msft · Accepted solution]

Hi @Anonymous ,

Does that make sense? If so, kindly mark my answer as the solution to close the case please. Thanks in advance.

Regards,
Frank

[Greg_Deckler]

What are the results for that data that you would want? There is probable a way to achieve it. If you want it based on the very last number, for example, you could use this:

Column 2 = ISEVEN(RIGHT(CONCATENATE([Column1],""),1)*1)

[Anonymous]

I would like to see only even whole numbers (no decimals). 

I tried using this formula for that but didn't work. 

Column 2 = ISEVEN(RIGHT(CONCATENATE(ECS_EZQuery40[DEBIT_AMOUNT],""),3)*3)

[Greg_Deckler]

Depends on how it is truncating the values, I imagine it might be rounding them perhaps?

https://docs.microsoft.com/en-us/dax/iseven-function-dax

[BhaveshPatel]

Hi @Anonymous 

Please see the attached link.https://dax.guide/iseven/

If number is not an integer, it is truncated to closet rounding.