Power Query Parameters - Dynamically Change the Output of Your Queries Depending on Their Value

[@MissMicrosoft]

Be among the first 100 to jump on board "The Query Editor" newsletter 🚀. It's packed with super-actionable tips and insights. Why should you be excited? 🌟 Because the first 100 subscribers will receive an exclusive 50% discount on my upcoming mini-course, set to drop early next year (or perhaps even sooner)! 🤞Just hit this link to subscribe thequeryeditor.beehiiv.com/subscribe 🚀🔥

[@ThGrum]

Excellent, there's nothing more to say. Thank you for that professional tutorial. Greetings from Bavaria.

[@MissMicrosoft]

Thank you very much! Glad you liked it.

[@paul46722]

Thanks for the concise and clear explanation.

[@charliechaplin2716]

Your channel is underrated! Good job. 👏 I shall recommend your channel in my network!

[@MissMicrosoft]

Thank you so much for the support Charlie Chaplin! It’s highly appreciated :)

[@iankr]

Excellent! Thank you. You always explain things clearly.

[@MissMicrosoft]

You’re most welcome Ian, glad I could help!

[@venkyr81]

Thanks for creating this vedio and adding multiple scenarios into it. This one vedio cover parameter well. Appreciate your effort.

[@heeren.9]

Medam, Nice Teaching.. Clear speech.. 👍🏻👍🏻

[@MissMicrosoft]

Thank you Hiren :)

[@maysarrose6649]

Thank you so much. 7:45 saved me from dying in an assignment 😭

[@MissMicrosoft]

I’m so glad I could help!!!

[@sudiptaghosh5855]

Hello Miss 🙂nicely expained...thanks a lot...keep uploading such videos...love from India

[@MissMicrosoft]

Thank you Sudipta for your kind words! I'm so glad the videos are helpful! If you haven't yet subscribed please subscribe as it really helps the channel grow, thank you so much for your support!

[@wayneedmondson1065]

Very nice! Well explained and useful information. Thanks for demonstrating. Thumbs up!!

[@MissMicrosoft]

Hi Wayne, thank you so much!!! And I took your suggestion and added the workbook in the description :)

[@wayneedmondson1065]

@@MissMicrosoft Great! Always helps to be able to follow along and practice :)) Thanks!!

[@RyanLeishman]

Really useful. I haven’t used parameters before. For the product table, instead of pulling in a table you could pull in a named range to power query.

[@MissMicrosoft]

Glad the video was helpful. Yes you could definitely use a named range instead.

[@MosheAtkins393]

Thanks, that was a great video, really helpfull

[@BNichols021]

Excellent video. I'm curious... can one use the value from the Excel cell to pass directly to the parameter? For example, if I wanted the parameter itself to dynamically change based on the month entered, is there a way to do this? I'm wanting to be able to pass the data input to a SQL query.

[@luigisir6893]

Excuse me, one question! But if instead of the month we had taken the day as a dynamic variable, would it have worked the same? Or does this dynamic filter only apply to text variables? Thank you for the great video and your answer!

[@kebincui]

Excellent 👍🏻 thanks

[@MissMicrosoft]

Thank you Kebin :) you’re most welcome

[@FRANKWHITE1996]

Thanks for sharing ❤

[@MissMicrosoft]

You’re welcome! 😊

[@gregbernard7861]

Great video / just subscribed!

[@MissMicrosoft]

Glad you enjoyed the video Greg. Thanks for subscribing!

[@Anything_Interesting]

how to query more than one value dynamically? for example I want jan and feb data to appear

[@republikadugave420]

Can this be a multiple selection?

[@MissMicrosoft]

Yes it can, please see 05:44 of this video for the second parameter created in the same query, so you can follow the same method to create as many parameters as you require in the same query.

[@mehrdadazimi2298]

Great! Thank you

[@MissMicrosoft]

You are welcome!

[@cassielemke5217]

Does this work in PowerBI?

[@icyyp5866]

cant seem to do this with date values any tips?

[@bhakti1908]

How can I pass the value in mysql query dynamically from the report section whatever user selected in filter 1) users select a single date that date should pass on my store procedure which I am calling in power bi while fetching the data from database How can I achieve this please help..

[@LenkaStašková-s3r]

thank you for video

[@Faisal63045]

Awesome thank you

[@MissMicrosoft]

It's a pleasure Faisal, glad it was helpful :)

[@edwinruizcolon5707]

Can I use the dynamic parameter for 6 different sheets in the same workbook? I am building a workbook with 6 tables and I want to do the dynamic parameter in another sheet and set it to connection only.

[@MissMicrosoft]

Yes you can most definitely do that.

[@edwinruizcolon5707]

@@MissMicrosoft Thanks. I was able to do it. I thought it was not possible at first because the filter was not applying to all sheets. The problem was in the data type configuration of some sheets .

[@MissMicrosoft]

@@edwinruizcolon5707 Glad to hear you were able to do it :) thanks for letting me know!

[@edwinruizcolon5707]

@@MissMicrosoft I am having the following issue. Not related to original question but hopefully you can help me. I developed an excel file with power query reading files from a folder on a shared folder of my organization. I, creator of the file, can refresh the file and query steps run without issue. However others members of my team cannot do it. They see the following error “Query references other queries or steps, so it may not directly access a data source. Please rebuild this data combination.”

[@MissMicrosoft]

@@edwinruizcolon5707 this can definitely be fixed, you can either ignore the error or fix it, fixing it is definitely the safer option, please watch this video here for the fix: kzbin.info/www/bejne/iX3RZqZ3gZiKpLM but if you want to ignore the error, please check out this video here: kzbin.info/www/bejne/imbEiKmnm56GpK8. I hope it helps!

[@eslamfahmy87]

Hi 👋..actually, very nice but could you distribute ur video into 2 or 3 videos with shortage muints and each video explain one point in order to understand for immediate levels 😀 Thanks 😊

[@MissMicrosoft]

Hi 👋 thanks for the suggestion 😊

[@mirekkryskapriv7445]

Great! Thanx!

[@MissMicrosoft]

You’re most welcome!

[@suryaatthesun1]

Excellent vedio on Parameters, Thanks

[@prakashpatil426]

How to use create parameter in version 2016

[@ankitsaxena5966]

What if I want to see two months data....

[@ziomekzedzielni1]

Make separate table where u will put all names of the months u want to have in output. Then use filter on the data table that filters it based on ur list of values

[@julie_chen]

👍👍👍👍

[@dineshzoomyt8879]

i want this concept from sql server. plz explain

[@MunasibSpace]

10/10 on choosing timestamps of referrals. Liked. Subscribed. What's your twitter handle?

[@MissMicrosoft]

Thank you for the support, it’s much appreciated! I’m not yet on Twitter, I’ll share it when I get an account.

[@MunasibSpace]

@@MissMicrosoft I have a small power query assignment to outsource and you seem a potential candidate. Please DM or connect.

[@MissMicrosoft]

Hi Danish, let's chat, please email me at [e-mail]