Excel Power Query Parameter from a Cell Value (using a Named Range or a Table)

Excel Power Query - how to make a dynamic parameter from a cell value (using a Named Range or a Table).

#excel #powerquery #spreadsheet

[Paladin]

My favourite Power Query Video 🤩. I have spent the past month going through all the power query videos in my watched history (literally hundreds), trying to find it. All I could remember about it was the ‘function’ element!!!

It’s 1st Sep and I found that I had watched it back on the 14th Apr so you can imagine how many videos I’ve rewatched in order to find it. Having watched it again, it was worth every hour I’ve spent looking. Thanks👍

[dcoltonbrown]

This was great! One of the best tutorials I have seen on any Power Query topic. Great for building a foundation to learn! Thank you.

[netboy]

Just save this to my list. In case I need to solve some problem in the future.
Just watched your video from 3 years ago about mail merge with Google docs. It helps to solve the problem in my new project. Thank you so much.

[julie_chen]

Packed with many valuable learning in this small exercise 😊

[melissaallisonwood]

This video has saved me a ton of time. Thank you! 🤩

[vasukollur]

Great Video. This is what i was exactly looking for. I used the parameters to query from database using this tutorial. Thanks for uploading this video!

[devpaulc]

Exactly what I was looking for! Thank you

[mgm]

This is great! thanksa lot for the super clear step by step explanation. Congratulations!

[anthonymerceron]

Fantastic video. Thank you so much. Helps me a lot

[abdullahquhtani]

Fantastic 👍🏼. That’ll be GREAT if you could parameters as dependent drop-down lists to make that better functional and to avoid not found results.MOREOVER, you could add a simple button to REFRESH☺️

[UweSeidel-dn]

Wuahhh, this is genius! Thanks for sharing <3

[srider]

Little long for the content but useful as always. I’m trying to use named range as starting and end points of a sheer region I need to grab. Haven’t found it yet. Maybe I will leverage different property besides content.

[tiffanyjanish]

great tutorial! I have 3 named ranges used as filters for a table, but I want to not require them all to have values. Applying the code in the video, it causes there to be 0 results when any of the cells are blank. Can you help with how to modify the code to allow for blank values...that way if there are no filters, all records would show in query table. Thanks!

[simonandhelenb]

This is great, however, I can't seem to get it to work picking up a date.

I've got dates on my worksheet, formatted as dates but when I try using the function to retrieve the date I get the message "We cannot convert the value #datetime(2022, 4, 1, 0, 0, 0) to type Text.". How do I work round this?

[kemadx]

I have seen a BUNCH of youtube videos in my years. Excel, python, SQL, Power BI etc. etc. your methodical walkthrough and explanation is one of the best 'teachings' I have experienced on youtube :) nice. And super cool functionality too.

Coupled with datalavidation on tablerange lookup, with a recorded macro to run update - this I am most definitely going to use.

Thank you :9

[sfrunze]

Great tutorial, thanks a lot for this. What would be the solution when you have to add /filter for the same parameter but multiple values, let’s say Olivia and Grace"?

[tomigonz]

Great content! Thank you. It was very useful. A question that I have: If I leave the "name_range" cells empty then I get no results in the table, which makes sense. However, it would be very useful in my case to get the whole table (as if it was not filtered) if there is no input in those cells, instead of no table. Is that possible? Thank you!

[ReachToLoveTheProphet]

Thank you, I learn so much from here, could you please make a video about how to put task list from google sheet to google task with google app script? thank you

[abdullahquhtani]

BTW, what if I wanna list the all without filters 🤔?

[michaeljohnston]

I’m trying to create a filter, but the filter could have 1 to several criteria for the same column. Your video illustrates one criteria per column and the position is 0. What would I have to do differently to turn that one criteria into a range of criteria and then use the count of that range for the positions in the list? For example, there may be 2 criteria with positions 0 and 1, then next time there may be 3 criteria with positions 0, 1, and 2. I just can’t figure out how to make those positions dynamic/variable.

I saw that someone asked about that earlier and was directed to another video. I watched that, but it didn’t answer my question.

Any help would be greatly appreciated!