DAX function
SELECTCOLUMNS — DAX function reference
Pick and rename columns.
Syntax
dax
SELECTCOLUMNS(<table>, <name1>, <expression1> [, <name2>, <expression2>, …])
Examples
dax
SELECTCOLUMNS(Sales, "Region", Sales[Region])
→ A table
dax
SELECTCOLUMNS(Sales, "OrderID", Sales[OrderID], "NetAmount", Sales[Amount] - Sales[Discount])
→ A slimmed-down, renamed virtual table
dax
UNION(
SELECTCOLUMNS(Actuals, "Period", Actuals[Month], "Value", Actuals[Amount]),
SELECTCOLUMNS(Budget, "Period", Budget[Month], "Value", Budget[PlanAmount])
)→ Combines two differently-shaped tables into one comparable schema
Common mistakes & gotchas
- SELECTCOLUMNS does not filter rows — it only reshapes/renames columns; wrap it in FILTER or CALCULATETABLE first if you also need to restrict rows.
- Column names are unrelated to the original column names, so downstream references must use the new alias (e.g., [Value]), not the source column name.
Related DAX functions
From Iterators & variables