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