SELECTCOLUMNS
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 |