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? ...
Not sure if it's the best, but I managed to significantly speed up the filtering by using supplementary tables containing only the months I want to keep in my main table, converting said tables to list (Transform pane > convert to list), it's an important step, without converting it to list, load still takes 6-8 minutes, then filter using List.Contains(#"supplementary_list", [yyyymm]) logic.
This way it takes ~30-60 secs to load.