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:

To get the files:
1. Go to Curbal Download Center > Dax Fridays
2. Get File #37

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