Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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).
I am using the following formula:
Does anyone know what the issue could be?
Thanks
Solved! Go to 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
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
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)
I would like to see only even whole numbers (no decimals).
I tried using this formula for that but didn't work.
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
Please see the attached link.https://dax.guide/iseven/
If number is not an integer, it is truncated to closet rounding.
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |