SELECTCOLUMNS

Syntax

SELECTCOLUMNS(<table>, <name>, <scalar_expression> [, <name>, <scalar_expression>]…) 

Tutorial with example

In todays video we will go through the SELECTCOLUMNS function in DAX.

Download example file:

Link to pbix file

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