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.
This is how we can add multiple columns in Power BI using DAX expression.