| description | title |
|---|---|
Learn more about: SELECTCOLUMNS |
SELECTCOLUMNS function (DAX) | Microsoft Docs |
[!INCLUDEapplies-to-measures-columns-tables-visual-calculations]
Returns a table with selected columns from the table and new columns specified by the DAX expressions.
SELECTCOLUMNS(<Table>, [<Name>], <Expression>, <Name>], …)
| 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. |
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.
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.
[!INCLUDE function-not-supported-in-directquery-mode]
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 |