where `❰number❱` is the number that you want to check for evenness.

Examples of the ISEVEN Function

Let's take a look at some examples to understand how the ISEVEN function works.

Example 1

Suppose we have a table `Sales` with a column `Amount` that contains the following values:

| Amount |

|--------|

| 100 |

| 75 |

| 50 |

| 25 |

| 0 |

To check whether each value in the `Amount` column is even or odd, we can create a new calculated column using the following DAX formula:

This will return the following values:

| Amount | IsEven |

|--------|--------|

| 100 | TRUE |

| 75 | FALSE |

| 50 | TRUE |

| 25 | FALSE |

| 0 | TRUE |

Example 2

Suppose we have a table `Employees` with a column `Age` that contains the following values:

| Age |

|-----|

| 25 |

| 32 |

| 47 |

| 54 |

| 61 |

To filter out the employees whose age is odd, we can create a new measure using the following DAX formula:

This will return the count of employees whose age is even.

The ISEVEN function in Power BI's DAX formula language is a handy tool to determine whether a given number is even or odd. It can be used in various scenarios, such as filtering out odd values or calculating even values. By understanding the syntax and examples of the ISEVEN function, you can leverage its power in your Power BI reports and dashboards.

Power BI DAX Training Courses by G Com Solutions (0800 998 9248)

Upcoming Courses

Contact Us