Forum Discussion

Jun_Wang's avatar
Jun_Wang
Advocate I
4 years ago

optimise power query codes

Hi there,   It'd highly appreciated if some one can help optimise power query codes.   I have a very big table with more than 500 columns along with nested tables. I used to use table.selectRows ...
Need Help
v-jingzhang's avatar
v-jingzhang
Community Support
4 years ago

Hi Jun_Wang 

 

Try this

= Table.TransformColumns(#"Grouped Rows",{"All Data Table", each Table.SelectRows(_, each [Period ID]=20210101)})

= Table.TransformColumns(#"Grouped Rows",{"All Data Table", each Table.SelectColumns(_, {"Employee ID","Salary"})})

 

Best Regards,
Jing
If this post helps, please Accept it as Solution to help other members find it.