SELECTCOLUMNS – select some columns from table (DAX – Power Pivot, Power BI)
The SELECTCOLUMNS function simply takes some column / columns from another table and create a new table from them.
For example, you can take only one column, Revenue, from this table:
The syntax of SELECTCOLUMNS is simple:
- Smaller table = SELECTCOLUMNS(Table1;"This day revenue";[Revenue])
It is table, column name in new table, column name in original table, column name in new table, column name in original table...)
If you needed not the column, but just the list of values (like 7 items for 7 weekdays), you may use DISTINCT.