Back to Browse

Parameter Query || Filter Power Query data from Excel

10.3K views
Feb 26, 2022
8:44

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 https://www.instagram.com/youexceltutorials/ 👉Facebook https://www.facebook.com/youexceltutorials 👉Twitter https://twitter.com/youexceltutor 👉 TikTok https://www.tiktok.com/@youexceltutor 👉LinkedIn https://www.linkedin.com/in/bunmi-sanusi/ 🎬Check these videos: Intro to Power Query https://youtu.be/h9XIsGTwUCo Power Query Playlist https://youtube.com/playlist?list=PLQkwVdU9TxqSQ09p9WMw6opRLm9w2wpDM Excel tips https://youtube.com/playlist?list=PLQkwVdU9TxqQkuB6PMiwQFz6j3WCs148q 🔽URL link to sample file https://docs.microsoft.com/en-us/power-bi/create-reports/sample-financial-download 📢” 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

Download

0 formats

No download links available.

Parameter Query || Filter Power Query data from Excel | NatokHD