Power Query (Excel) + M Code | Dynamic Filter - No Code & M Code

Published: 26 November 2022
on channel: Bsmart2gether

887

This video will explain how the Table.SelectRows function (i.e. filter) works. Also, the video covers a few dynamic filtering examples from no code to M code.

Topic:
0:14 - Overview
0:40 - Method 1 - Merge
1:30 - Filter explained
2:09 - Method 2 - List.Contains (One and more columns - narrow search)
3:37 - Method 3 - List.ContainsAny (One and more columns - Broader search)

Workbook:
N/A

On this page of the site you can watch the video online Power Query (Excel) + M Code | Dynamic Filter - No Code & M Code with a duration of hours minute second in good quality, which was uploaded by the user Bsmart2gether 26 November 2022, share the link with friends and acquaintances, this video has already been watched 887 times on youtube and it was liked by 45 viewers. Enjoy your viewing!

600