Forum Discussion
List.Contains() is slow
I tried to filter a column based on a list I used List.Contains() but it is very slow = Table.SelectRows(Medidas, each (List.Contains(Resta,[Cliente])=true )) Please your help with a faster ...
Definitely use List.Buffer, as in each List.Contains(List.Buffer(LookupList), [Column])
ALWAYS use List.Buffer in your List.Contains!
--Nate
I use List.Buffer and it works but after when I collapse that column, very slow again.