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

Hi Jimmy Tao,

 

Great article. Big thanks for your post.


When creating a table using your guidance above, is there a way to exclue brining in blanks?

 

I've successfully used the function string in the attached image and it works. But if the column I reference has blanks, PowerBI won't create the table.

 

I'm hoping you could provide a solution where I can exclude blanks and successfully create a table.


I've tried NOT BLANK(), NOT IS BLANK, and tried using a boolean arguement (IF), but I can't figure it out.

 

 

Thx

DAX Richard