Parameter Query || Filter Power Query data from Excel
This video describes parameters in power query for Excel. Parameters give you the flexibility to change the output of your queries. You will learn how to use a parameter to filter data based on single and multiple criteria and how to return all the data when the parameter is blank.
Please check out other videos on my channel and don't forget to comment, like, share, subscribe and click the bell icon so you'll get a notification when the next video is uploaded. Thanks!
Content
0:01 Intro
0:48 Get data from the web
2:41 Filter – single criteria
4:16 Privacy level setting
5:00 Adjust column width
5:23 Filter – blank query
7:02 Filter – multiple criteria
Thank you!
Connect with me on:
👉Instagram / youexceltutorials
👉Facebook / youexceltutorials
👉Twitter / youexceltutor
👉 TikTok / youexceltutor
👉LinkedIn / bunmi-sanusi
🎬Check these videos:
Intro to Power Query • Intro to Power Query || Load Data fro...
Power Query Playlist • Power Pivot and Power Query
Excel tips • Excel Tips
🔽URL link to sample file https://docs.microsoft.com/en-us/powe...
📢” I pray that God, the source of hope, will fill you completely with joy and peace because you trust in him.” Romans 15:13a (NLT)
#powerquery #msexcel #parameter #youexceltutorials
Watch video Parameter Query || Filter Power Query data from Excel online without registration, duration hours minute second in high quality. This video was added by user YouExcel Tutorials 26 February 2022, don't forget to share it with your friends and acquaintances, it has been viewed on our site 9,416 once and liked it 272 people.