SUM is a DAX function that adds all the numbers in a specified column.
Syntax
SUM( ColumnName )| Argument | Properties | Description |
|---|---|---|
| ColumnName | The column that contains the numbers to sum. |
SUM
Updated on
SUM is a DAX function that adds all the numbers in a specified column.
SUM( ColumnName )| Argument | Properties | Description |
|---|---|---|
| ColumnName | The column that contains the numbers to sum. |
A decimal number.
If you want to filter the values that you are summing, you can use the SUMX function and specify an expression to sum over.
The following example adds all the numbers that are contained in the column, Amt, from the table, Sales.
= SUM(Sales[Amt])
Other functions related to SUM are:
2023-2024 © BI Gorilla. All rights are reserved. Information from Microsoft docs is property of Microsoft Corp. | Privacy Policy