Forum Discussion
Filter by highest and second highest value in Power Query
Hi everyone, I have a table containing data from different months. I want to filter for the latest and the previous months only. My question is, what is the most efficient way of doing this? ...
Hi mafaber ,
You can improve the performance of power query, such as: Remove unnecessary columns, Remove unnecessary rows, Group by and summarize and so on.
Besides, how about using Keep Top Rows after sorting?
For more details, please refer to:
Data reduction techniques for Import modeling
Best Regards,
Jianbo Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.