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 🚀🔥
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!
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!
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 😊
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..
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
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.
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 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 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.”
@@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: ruclips.net/video/SLn5sAL3WnQ/видео.html but if you want to ignore the error, please check out this video here: ruclips.net/video/T5aWvqf9SnM/видео.html. I hope it helps!
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
🚀🔥
Your channel is underrated! Good job. 👏 I shall recommend your channel in my network!
Thank you so much for the support Charlie Chaplin! It’s highly appreciated :)
Excellent, there's nothing more to say. Thank you for that professional tutorial. Greetings from Bavaria.
Thank you very much! Glad you liked it.
Thanks for creating this vedio and adding multiple scenarios into it. This one vedio cover parameter well. Appreciate your effort.
Excellent! Thank you. You always explain things clearly.
You’re most welcome Ian, glad I could help!
Hello Miss 🙂nicely expained...thanks a lot...keep uploading such videos...love from India
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!
Thanks, that was a great video, really helpfull
Medam, Nice Teaching.. Clear speech.. 👍🏻👍🏻
Thank you Hiren :)
Very nice! Well explained and useful information. Thanks for demonstrating. Thumbs up!!
Hi Wayne, thank you so much!!! And I took your suggestion and added the workbook in the description :)
@@MissMicrosoft Great! Always helps to be able to follow along and practice :)) Thanks!!
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.
Glad the video was helpful. Yes you could definitely use a named range instead.
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!
Excellent vedio on Parameters, Thanks
thank you for video
Thank you so much. 7:45 saved me from dying in an assignment 😭
I’m so glad I could help!!!
Excellent 👍🏻 thanks
Thank you Kebin :) you’re most welcome
Great! Thank you
You are welcome!
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 😊
Hi 👋 thanks for the suggestion 😊
Thanks for sharing ❤
You’re welcome! 😊
how to query more than one value dynamically? for example I want jan and feb data to appear
Great video / just subscribed!
Glad you enjoyed the video Greg. Thanks for subscribing!
Awesome thank you
It's a pleasure Faisal, glad it was helpful :)
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..
Great! Thanx!
You’re most welcome!
How to use create parameter in version 2016
cant seem to do this with date values any tips?
Does this work in PowerBI?
What if I want to see two months data....
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
Can this be a multiple selection?
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.
👍👍👍👍
i want this concept from sql server. plz explain
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.
Yes you can most definitely do that.
@@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 .
@@edwinruizcolon5707 Glad to hear you were able to do it :) thanks for letting me know!
@@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.”
@@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: ruclips.net/video/SLn5sAL3WnQ/видео.html but if you want to ignore the error, please check out this video here: ruclips.net/video/T5aWvqf9SnM/видео.html. I hope it helps!
10/10 on choosing timestamps of referrals. Liked. Subscribed. What's your twitter handle?
Thank you for the support, it’s much appreciated! I’m not yet on Twitter, I’ll share it when I get an account.
@@MissMicrosoft I have a small power query assignment to outsource and you seem a potential candidate. Please DM or connect.
Hi Danish, let's chat, please email me at missmicrosoft@ignite-work.com