Power Query - Filter Nested Table Before Expanding

In this video i show you how to filter a nested table before expanding. The conventional method is to expand first then filter using the Power Query UI but this slows down your queries especially on big workbooks.
#data #dataanalytics #powerquery #powerbi #excel #exceltutorial

links
Power Query example files
https://github.com/jbotes/powerbiTuto...
Source files in folder
https://github.com/jbotes/powerbiTuto...
https://github.com/jbotes/powerbiTuto...
https://github.com/jbotes/powerbiTuto...
https://github.com/jbotes/powerbiTuto...

M Query documentation
https://learn.microsoft.com/en-us/pow...
https://learn.microsoft.com/en-us/pow...
https://learn.microsoft.com/en-us/pow...

my site
https://www.basensei.com

my linked in page
  / james-botes-basensei