EVEN

How to Use the Power BI DAX function EVEN

Syntax of the EVEN Function

The syntax of the EVEN function is simple. It takes only one argument, which is the number you want to round up to the next even number. The syntax of the EVEN function is as follows:


EVEN(number)


Here, "number" refers to the value you want to round up to the next even number.

For example, if you want to round up the number 5 to the next even number, you can use the following formula:


=EVEN(5)


This will return 6, which is the next even number greater than or equal to 5.

Examples of Using the EVEN Function in Power BI

Let's look at some examples of using the EVEN function in Power BI:

Example 1: Rounding Up Sales Figures

Suppose you have a table of sales data in Power BI, and you want to round up the sales figures to the next even number. To do this, you can create a new column in the table and use the EVEN function to round up the sales figures. Here's how you can do it:

1. Select the table of sales data in Power BI.

2. Go to the "Modeling" tab and click on "New Column."

3. In the formula bar, enter the following formula:


Rounded Sales = EVEN(Sales)


Here, "Sales" refers to the column of sales figures in the table. The new column "Rounded Sales" will contain the rounded up sales figures.

Example 2: Calculating Bonus Payments

Suppose you have a table of employee data in Power BI, and you want to calculate bonus payments based on the total sales made by each employee. To do this, you can create a new column in the table and use the EVEN function to round up the total sales figures. Here's how you can do it:

1. Select the table of employee data in Power BI.

2. Go to the "Modeling" tab and click on "New Column."

3. In the formula bar, enter the following formula:


Bonus = EVEN(Total Sales)*100


Here, "Total Sales" refers to the column of total sales made by each employee. The new column "Bonus" will contain the rounded up total sales figures multiplied by 100 to calculate the bonus payments.

The EVEN function in Power BI is a powerful tool for rounding up numbers to the next even number. Whether you're working with sales data or employee data, the EVEN function can help you create custom calculations and aggregations for data modeling and analysis. By following the steps outlined in this article, you can start using the EVEN function in your Power BI reports and dashboards today.

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

Upcoming Courses

Contact Us

    Subject

    Your Name (required)

    Company/Organisation

    Email (required)

    Telephone

    Training Course(s)

    Your Message

    Upload Example Document(s) (Zip multiple files)