SELECTCOLUMNS

Applies to: Calculated column Calculated table Measure Visual calculation

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

Syntax

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

Parameters

Term Definition
Table Any DAX expression that returns a table.
Name The name given to the column, enclosed in double quotes.
Expression Any expression that returns a scalar value like a column reference, integer, or string value.

Return value

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.

This function is not supported for use in DirectQuery mode when used in calculated columns or row-level security (RLS) rules.

Example

For the following table named Customer:

Country State Count Total
IND JK 20 800
IND MH 25 1000
IND WB 10 900
USA CA 5 500
USA WA 10 900
SELECTCOLUMNS(Customer, "Country, State", [Country]&", "&[State])

Returns,

Country, State
IND, JK
IND, MH
IND, WB
USA, CA
USA, WA