Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

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).    I a...
General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • v-frfei-msft's avatar
    v-frfei-msft
    7 years ago

    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

v-frfei-msft's avatar
v-frfei-msft
Icon for Community Support rankCommunity Support
7 years ago

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's avatar
v-frfei-msft
Icon for Community Support rankCommunity Support
7 years ago

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