★ Want to automate Excel? Check out our training academy ★
[ Ссылка ]


★ Download the example file★
[ Ссылка ]

★ About this video ★
Filtering in Power Query reduces the table to include only those items which meet specific criteria. However, Power Query doesn’t have an option to filter to include all items. In Excel, we can use the asterisk ( * ) as a wildcard character to match any text. Therefore, if we want to include all items in a Filter, we just use a single asterisk. However, Power Query doesn’t have equivalent functionality. So, in this video, we will look at a method to create a filter All effect in Power Query.


★ Download 30 most useful Excel VBA Macros ebook for FREE ★
[ Ссылка ]


★ Where to find Excel Off The Grid ★
Blog: [ Ссылка ]
Twitter: [ Ссылка ]

#MsExcel #PowerQuery

свернуть