How To Filter Data by a List in Power Query [M Coding Guide]
In this video, learn how to use a list to filter a data table in Power Query - for Excel and Power BI users. Using this simple, but effective, M function we can dynamically filter a data table by a pre-defined list of values.
We’ll guide you through:
How to convert a query to a list in Power Query
Show you how to use the List.Contains M function in Power Query
Dynamically filter a data table in Power Query by a list
You can download our template files here: https://goanalyticsbi.com/product/tem...
By the end of this video, you’ll have learned a new M programming function (List.Contains) and be able to filter a data table by a list in Power Query - whether you're working on Excel or Power this simple ETL step will make your life much easies!
Hope you enjoy this video and we'll see you in the next one!
For more how-to and tips & tricks videos on Power BI make sure to subscribe to our channel.
About Go Analytics Inc.
Go Analytics is a data analysis and visualization consulting firm specializing in Microsoft Power BI. For any Power BI inquiries, please contact us at https://goanalyticsbi.com/contact.
Need help getting started with Power BI? Let's connect!
Visit our website at https://goanalyticsbi.com
Follow us on Twitter at / goanalyticsinc
Connect with us on LinkedIn at / go-analytics-inc
***
Note: Go Analytics Inc. is not affiliated with Microsoft. Thoughts are our own.