# 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) Power BI DAX Intensive Training Course £1,260.00 – £31,860.00 Select optionsContinue Loading Done Power BI DAX Introduction £474.00 – £11,700.00 Select optionsContinue Loading Done Power BI DAX Intermediate £474.00 – £11,700.00 Select optionsContinue Loading Done Power BI DAX Advanced £474.00 – £11,700.00 Select optionsContinue Loading Done Upcoming Courses 16-18 September 202411-13 November 2024 Contact Us Subject Your Name (required) Company/Organisation Email (required) Telephone Training Course(s) Power BI Intensive TrainingPower BI introduction Power BI IntermediatePower BI AdvancedDAXPower Query MPower BI CertificationPower BI AdministrationPower PlatformPower AutomatePower AppsOTHER Your Message Upload Example Document(s) (Zip multiple files) ```
``` ```
``` ```
``` ```
``` ```
``` ```