SELECTCOLUMNS Function (DAX)
Adds calculated columns to the given table or table expression.
SELECTCOLUMNS(<table>, <name>, <scalar_expression> [, <name>, <scalar_expression>]…)
Parameters
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.
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>, <scalar_expression> arguments, and each expression is evaluated in the context of a row from the specified <table> argument.
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.
For the following table named Info:
| 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(Info, “StateCountry”, [State]&”, ”&[Country])
Returns:
| StateCountry |
|---|
| IND, JK |
| IND, MH |
| IND, WB |
| USA, CA |
| USA, WA |