Add Multiple Columns Using DAX In Power BI

Overview

Sometimes, we need to perform “addition” operation on multiple columns by rows.

Let’s take an example.

I have two columns named “Test1” and “Test 2” in the below table.

Now, let’s add the columns “Test 1” and “Test 2” and make one-third of an additional column named “Total.”

We can achieve the same using Power BI DAX expressions.

There are two ways to achieve the same sum operation on multiple columns.

• Use DAX expression in Calculated column

• Use DAX expression in Measure column

Based on the requirement, we can choose whether to create a calculated column or measure column.

Now let’s elaborate both in detail.

Use DAX expression in calculated column

Use the following DAX expression to create a new calculated column.

CC Total = Sheet1[Test 1 ] + Sheet1[Test 2]

Here we have just performed a “+” operation between numeric fields.

Let’s check the output in table visual. Here is the result.

Use DAX expression in measure column

Use the following DAX expression to create a new measure column.

Measure Total = SUM(Sheet1[Test 1 ])+SUM(Sheet1[Test 2])

Let’s check the output in a table visual. Here is the result.

If we compare both the results, the output would be the same.

Conclusion:

This is how we can add multiple columns in Power BI using DAX expression.