How to filter a Power Query table with a list

Описание к видео How to filter a Power Query table with a list

Filter a table with a list of values in Power Query (similar to a SQL IN operator). You may be tempted to use a MERGE step in Power Query as a workaround, which would allow you to filter a table with another one-column table. But this can be detrimental to performance. Filtering with a list is not only simpler, but also supports query-folding for database sources. This can dramatically improve performance.

Basic Formula:
Table.SelectRows(x,each List.Contains(y,[z]))

where
x = the name of your previous step
y = the name of the list
z = the column in your table that you want to filter

#powerquery #excel #powerbi #powerpivot #dax

Комментарии

Информация по комментариям в разработке

Похожие видео