AddColumns
Table
Adds calculated columns to table expression.
Parameters
table -> Table
Table or table expression for which columns need to be added.
name -> String
Name of the column to be added.
expression ->
DAX expression that returns a value for each row of passed table.
Returns
Type: Table
Returns table with new column added.
Details
- Multiple column and expressions can be added to AddColumns.
- Minimum of one column needs to be added.
Examples
The following formula returns table with columns of Employee along with 'NewColumn' and 'NewColumn2' columns.
= ADDCOLUMNS( Employee, "NewColumn", 1 "NewColumn2", 2 )