SelectColumns
Table
Adds calculated columns to table expression with each column for each pair of name and 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 same rows as passed table but with columns equal to count of name and expressions passed. All the other columns are removed
Details
- SELECTCOLUMNS and ADDCOLUMNS has function signature.
Examples
The following formula returns table with 'NewColumn' and 'NewColumn2' columns. Other columns from Employee are removed.
= SELECTCOLUMNS( Employee, "NewColumn", 1 "NewColumn2", 2 )