Forum Discussion
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).
Example
I am using the following formula:
Does anyone know what the issue could be?
Thanks
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
6 Replies
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)
Hi Anonymous
Please see the attached link.https://dax.guide/iseven/
If number is not an integer, it is truncated to closet rounding.
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
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
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
