cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
pcastro Frequent Visitor
Frequent Visitor

ISEVEN FUNCTION not working correctly

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). 

 

123.PNGExample

I am using the following formula: 

 

TESTEVEN  = ISEVEN(ECS_EZQuery40[DEBIT_AMOUNT])

 

Does anyone know what the issue could be? 

 

Thanks 

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: ISEVEN FUNCTION not working correctly

Hi @pcastro ,

 

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

 

Regards,
Frank

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
6 REPLIES 6
Super User
Super User

Re: ISEVEN FUNCTION not working correctly

Hi @pcastro 

 

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

 

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

Thanks & Regards,
Bhavesh

Love the Self Service BI.
Please use the 'Mark as answer' link to mark a post that answers your question. If you find a reply helpful, please remember to give Kudos.
Super User
Super User

Re: ISEVEN FUNCTION not working correctly

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

 


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!


Super User
Super User

Re: ISEVEN FUNCTION not working correctly

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)

Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!


Highlighted
pcastro Frequent Visitor
Frequent Visitor

Re: ISEVEN FUNCTION not working correctly

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)
Community Support Team
Community Support Team

Re: ISEVEN FUNCTION not working correctly

Hi @pcastro ,

 

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])

Capture.PNG

 

Regards,

Frank

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Community Support Team
Community Support Team

Re: ISEVEN FUNCTION not working correctly

Hi @pcastro ,

 

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

 

Regards,
Frank

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.