Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

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

 

ExampleExample

I am using the following formula: 

 

TESTEVEN  = ISEVEN(ECS_EZQuery40[DEBIT_AMOUNT])

 

Does anyone know what the issue could be? 

 

Thanks 

1 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

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

View solution in original post

6 REPLIES 6
v-frfei-msft
Community Support
Community Support

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

Capture.PNG

 

Regards,

Frank

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

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

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

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)

@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...
Anonymous
Not applicable

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
Super User
Super User

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

 


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...
BhaveshPatel
Community Champion
Community Champion

Hi @Anonymous 

 

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.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.