Power Query - Filter Multiple Columns at once🦖😶🌫️
In this video i show you how to use some list functions to quickly filter multiple columns in one go. #data #dataanalytics #powerbi #powerquery #excel #mquery 🦖😶🌫️
Follow along file:
https://github.com/jbotes/powerbiTuto...
Functions Used
To add columns to a Table
Table.AddColumn
To check for specific values in lists
List.ContainsAny
To check for true or false matches in lists
List.MatchesAny