Which DAX function calculates a measure for every row of a table and returns a table?

Question

Power BI — Medium

Which DAX function calculates a measure for every row of a table and returns a table?

Accepted Answer

The ADDCOLUMNS function in DAX calculates a measure for every row of a table, returning a table with the added columns. This function is specifically designed to add new columns to a table. SUMX and SUMMARIZE are primarily used for aggregation, whereas SELECTCOLUMNS only returns existing columns.