Difference between Sum and Sumx? And also Summerize vs Summerized column?

Question

Accepted Answer

Sum calculates the sum of a column, while Sumx calculates the sum of an expression. Summarize creates a new table with summarized data, while Summarized column adds a calculated column to an existing table.

Sum is used to calculate the sum of a column in a table.
Sumx is used to calculate the sum of an expression over a table or a group of rows.
Summarize creates a new table by grouping and summarizing data from an existing table.
Summarized column adds a calculated column to an existing table based on a summarization expression.

Accepted Answer

`SUM` calculates a sum of values in a column, while `SUMX` evaluates an expression for each row in a table and then sums the results. `SUMMARIZE` creates a summary table based on specified groupings, while `SUMMARIZED COLUMN` adds a calculated column to an existing table based on grouped values.

Accepted Answer

sumx is a itterative function,where it could be used via measure to sum an expression,whereas sum is just used to summarize data

Accepted Answer

SUMX is the sum of an expression, but SUM is just summarizing values of one single column

Difference between Sum and Sumx? And also Summerize vs Summerized column?

Top KPMG India Power BI Developer interview questions & answers

Popular interview questions of Power BI Developer