Filtering a Table to a Dynamic List of Values using Power Query and Power BI
This video will show you how to filter a column in a table to a list of values. The greatest thing when using this method is that there are endless ways to get the list that serves as your filter, from top N to percentiles and so on. The possibilities are endless, but in the end, it all rests on the technique described in this video. It should be noted that the same thing can be achieved by merging two queries and choosing the Inner Join as the join type, but both techniques have their place as they do represent different steps and different resource needs.
This tutorial was made using Excel 365 but is applicable to older versions of Excel all the way back to Excel 2010.
Chapters:
0:00 Excel Olympics Animation
0:08 Intro
0:21 Explanation
0:46 Filtering a Table to a list of values
3:53 Aditional options
5:05 Outro
You can read the accompanying blog post here: https://bit.ly/2Pf7v9V
Gear Used:
US Links
Camera: Canon EOS R6 - https://amzn.to/3e9zxML
Microphone: AKG C3000 (Analog Mic) - https://amzn.to/3tYd37w
Audio converter: Zoom UAC-2 - https://amzn.to/3dgM8wS
Laptop: Dell XPS 15 - https://amzn.to/3w8CyoK
Lights: Elgato Key Light - https://amzn.to/3rurte7
EU Links
Camera: Canon EOS R6 - https://amzn.to/3tubwGy
Microphone: AKG C3000 (Analog Mic) - https://amzn.to/32pi2m0
Audio converter: Zoom UAC-2 - https://amzn.to/3amDRXP
Laptop: Dell XPS 15 - https://amzn.to/3effMmT
Lights: Elgato Key Light - https://amzn.to/3vcs6v9
Green Screen (visible in bloopers): https://amzn.to/3ajUm6Y
Recorded With: Camtasia - https://www.techsmith.com/video-edito...
Subscribe for more Excel tutorials: http://bit.ly/EOYTsub
Subscribe for the Excel Olympics Newsletter: https://bit.ly/3w3rkjK
DISCLAIMER: Links included in this description might be affiliate links. If you purchase a product or service with the links that I provide I may receive a small commission with NO additional charge to you! Thank you for your support!
#Excel #ExcelOlympics #gasperkamensek