Forum Discussion

iamprajot's avatar
iamprajot
Responsive Resident
8 years ago
Solved

SELECTCOLUMNS or Table.SelectColumns ?

Hi I need to create a new table using columns from existing few tables and I need to know what is the best option to go for.   SELECTCOLUMNS or let     Source = Table.SelectColumns('Original So...
Need Help
  • v-yuta-msft's avatar
    v-yuta-msft
    8 years ago

    Hi iamprajot,

     

    Yes, you can use DAX functions like SUMMARIZE() or ADDCOLUMNS() or ( SELECTCOLUMNS(), UNION() ) to create a custom table from exsiting tables.

     

    Regards,

    Jimmy Tao

v-yuta-msft's avatar
v-yuta-msft
Community Support
8 years ago

Hi iamprajot,

 

Yes, you can use DAX functions like SUMMARIZE() or ADDCOLUMNS() or ( SELECTCOLUMNS(), UNION() ) to create a custom table from exsiting tables.

 

Regards,

Jimmy Tao

DAXRichArd's avatar
DAXRichArd
Resolver I
7 years ago

CANCEL REQUEST FOR HELP

 

I figured it out.

TEST =
DISTINCT (
SELECTCOLUMNS (
FILTER ( 'Merged Tables', [Airline Name] <> BLANK () ),
"Airline Name", 'Merged Tables'[Airline Name]
)
)