ADDCOLUMNS Adds calculated columns to the given table or table expression.


ADDCOLUMNS(table, name, expression[, name, expression]…)


table – Any DAX expression that returns a table of data.
name – The name given to the column, enclosed in double quotes.
expression – Any DAX expression that returns a scalar expression, evaluated for each row of table.

Return Value

A table with all its original columns and the added ones.

Reference Data

DAX Functions / Statistical Functions / ADDCOLUMNS