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])