Power BI SUM Vs SUMX | Dax Functions
#SUMvsSUMX
#dax
#powerBI
#powerbizone
Dax Function : SUM takes a single column as an argument
Syntax: SUM(column)
Return Type: Decimal Number
SUM is very simple in nature it just adds up values in a particular column.
Dax Function: SUMX takes an expression as an argument .
An expression can be “Column1*Column2” or “Col1 – Col 2+Col3” etc
Syntax: SUMX(table, expression)
Return Type: Decimal Number
Watch my video to get an easy explanation of both the SUM Vs SUMX Dax functions. One of the basic differences is that while the dax function SUM takes in only one column as an argument the dax function SUMX can take multiple columns as an expression .Remember both of them are measures in Power BI
For more please visit our Power BI zone article :
https://powerbizone.com/sum-vs-sumx/
