Forum Discussion

SaaM's avatar
SaaM
Helper II
5 years ago
Solved

What is optimal ? Select Columns then Select rows or Select rows then Select Columns

Hello,

 

I was wondering what is optimal to do for my situation.

 

I have a table with 12k rows and 50 columns.

 

What is the best option ? 1 or 2 ? or another solution ?

 

1 - Table.SelectColumns(Table.SelectRows(Table1, (sel) => sel[item] = item and sel[line] = line), {"col1", "col2"})

 

2 - Table.SelectRows(Table.SelectColumns(Table1 , {"col1", "col2"}),  (sel) => sel[item] = item and sel[line] = line))

 

with Table.SelectRows(Table1, (sel) => sel[item] = item and sel[line] = line) =>it  gives me one row

 

 

Thanks

 

Kind regards,

Saam

 

Need Help
  • edhans's avatar
    edhans
    5 years ago

    You can run some tests and time it, but you'll often find it doesn't matter. Power Query will optimize the code and run some steps in a different order you put them in when it executes your steps. 

1 Reply

  • edhans's avatar
    edhans
    Community Champion
    5 years ago

    You can run some tests and time it, but you'll often find it doesn't matter. Power Query will optimize the code and run some steps in a different order you put them in when it executes your steps.