In Power BI, if you are looking to add up multiple fields and display it in a new field, you would want to create a new formulated column. This is different than a calculated field because it will allow you to add up multiple columns for each customer row and will display the total of those columns in each row.
STEPS TO CREATE:
-
In Power BI, on the left-hand toolbar, select the data page.
-
On the right-hand side of the data page, select the table you want to add the field to. (In this example, I will be calculating the totals of the LateAging fields on the Customer table.)
-
Once the Table loads in, select the "New Column" button under the "Table Tools" section of the Power BI toolbar at the top of the page.
-
This will create a generic field with no data. You can enter the intended formula for this field directly above the grid. **NOTE** This is also where you can modify the formula at a later date if needed. Select the field to have the formula populate above the grid.
-
Replace the word "Column" with whatever you want to name the new field, then enter the formula after the "=" symbol. (In this example, I am creating a LateTotal field using the following calculation)
-
The formula above follows the below structure.
FieldName = TableName[Field1] + TableName[Field2] + TableName[Field3]
-
Select "Enter" after you finalize your changes. If everything goes correctly, your field should populate the total for each row.