3 ways of filtering data using dynamic lists - Power Query (Excel and Power BI)
Follow me on Twitter: @GracielaPowerGI Welcome!
This video shows how to filter data using dynamic lists using Power Query.
It shows 3 ways:
1. Filter using Exact match and List.Contains function 0:00 - 4:42
2. Filter using Exact match and Merge functionality 4:43 - 8:10
3. Filter using "Contains" logic and List.Accumulate function 8:11 - 12:12
Funtions used:
List.Contains(ListQuery, [Customer])
List.Accumulate(FilterList, null, (state, current) =[greater than] if Text.Contains([Customer], current) then current else state)
Article referenced in the video:
https://datachant.com/2016/06/02/powe...
Sample file can be found here:
https://powergi.net/resources/FilterB...
We can help! contact us at [email protected]
Watch video 3 ways of filtering data using dynamic lists - Power Query (Excel and Power BI) online without registration, duration hours minute second in high quality. This video was added by user Power GI 04 February 2021, don't forget to share it with your friends and acquaintances, it has been viewed on our site 17,757 once and liked it 301 people.