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
Смотрите видео Parameter Query || Filter Power Query data from Excel онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь YouExcel Tutorials 26 Февраль 2022, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 9,416 раз и оно понравилось 272 людям.