In this Power BI Tutorial, we will learn about the Power BI SUM multiple columns and how to sum 2 columns in Power BI.
Additionally, we will discuss the topics below:
- Power BI sum multiple columns
- Power BI sum group by multiple columns
- Power BI sum two columns from different tables
- Power BI measure sum multiple columns
- Power BI add two columns together
- Power BI sum columns by row
- Power BI dax sum multiple columns with filter
- Power query sum multiple columns
Power BI Sum Multiple Columns
Sum multiple columns Power BI functionality allows you to add up the values in several columns of your dataset to create a new total column.
To calculate the sum of multiple columns, we can use the SUMX function in Power BI. The syntax for the Power BI Dax SUMX() function is shown below:
SUMX(<table>, <expression>)Where:
- SUMX = This function calculates the sum of a series of values.
- <table> = It specifies the table from which to retrieve the values for calculation.
- <expression> = It represents the expression to be evaluated for each row of the table, with its results summed up.
How to Sum 2 Columns in Power BI?
Let’s say you’re managing sales data in Power BI for your company. You have two columns, “Online Sales” and “Offline Sales,” each containing the total sales figures for your products. Now, you want to analyze the total sales regardless of whether they occurred online or offline.
Here, we have an Excel file that contains the Online Sales and Offline Sales columns.
Now follow the below steps:
1. Open Power BI Desktop and load data using the Get data option. Then, you can see data in the Data pane.
2. Under the Modeling tab, click “New column.”
3. In the formula bar, put the below expression. Then click Commit.
Total Sales = 'Table1'[Offline Sales] + 'Table1'[Online Sales]Where:
- Total Sales = This is the name of the new column.
- Table1′[Offline Sales] = This part says, “Get the value of the Offline Sales column from Table1.”
- ‘Table1′[Online Sales] = Similarly, this part means “get the value of Online Sales column from Table1.”
4. First, switch to the Table view. Then, you’ll see the total sales column that was created.
This way, we can sum 2 columns in Power BI.
Power BI Sum Multiple Columns
Here, in this example, we calculated the sum of multiple columns using the SUMX function in Power BI.
Let’s imagine you want to track your daily sales of different product categories using Power BI.
You have a dataset with columns like “Fruits Sales,” “Vegetables Sales,” and “Dairy Sales,” each representing the sales amount for that category on a given day.
Now follow the below steps:
1. Open Power BI Desktop and load data using the Get data option. Then, you can see data in the Data pane.
2. In the “Home” tab, click on “New measure.”
3. In the formula bar, type the below formula:
TotalSales = SUMX('SalesData', 'SalesData'[Fruits Sales] + 'SalesData'[Vegetables Sales] + 'SalesData'[Dairy Sales])Where:
- TotalSales = This is the name we’re giving to the result of our calculation, which is the total sales.
- SalesData = This line defines a table or data source named “SalesData.”
- ‘SalesData'[Fruits Sales] = This assigns a column within the “SalesData” table called “Fruits Sales,” which likely contains sales data for fruits.
- ‘SalesData'[Vegetab