SELECTCOLUMNS DAX Function (Table manipulation)

Returns a table with selected columns from the table and new columns specified by the DAX expressions.

Syntax

SELECTCOLUMNS ( <Table>, <Name>, <Expression> [, <Name>, <Expression> [, … ] ] )

Parameter	Attributes	Description
Table		The table from which columns are selected.
Name	Repeatable	The name of the new column to be added.
Expression Row Context	Repeatable	The expression for the new column to be added.

Return values

Table An entire table or a table with one or more columns.

A table with the same number of rows as the table specified as the first argument. The returned table has one column for each pair of Name, Expression arguments, and each expression is evaluated in the context of a row from the specified Table argument.

Remarks

SELECTCOLUMNS has the same signature as ADDCOLUMNS, and has the same behavior except that instead of starting with the <Table> specified, SELECTCOLUMNS starts with an empty table before adding columns.

Related functions

Other related functions are:

ADDCOLUMNS

Last update: Oct 20, 2018 » Contribute » Show contributors

Contributors: Alberto Ferrari, Marco Russo

MSDN documentation: https://msdn.microsoft.com/en-us/query-bi/dax/selectcolumns-function-dax