I am new in Excel Power Query. Just found out how it is powerful. I wondered how cell parameters a list like features. I thought that it is query. Thank to your video, I found out that they are simple cell parameters with list Data Validation. Many thanks and good luck!
In power query you can use AND/OR criteria in a filter & you can choose a parameter to link to it, so yes it should work for a filter. For other things like get data from file/folder where it combines two folders on the fly I would avoid that & use append instead
I am new in Excel Power Query. Just found out how it is powerful. I wondered how cell parameters a list like features. I thought that it is query. Thank to your video, I found out that they are simple cell parameters with list Data Validation. Many thanks and good luck!
Brilliant. I love this as this was the easiest way of using cell value as parameter
Thanks! Glad you found it useful :)
Amazing! Thank you!
Glad you liked it!
Hey, thank you much.
No worries! Glad you liked it!
Is there a way to do this but with 2 filtered value instead of 1 ? Like I want to filter to get X and Y instead of just X ?
In power query you can use AND/OR criteria in a filter & you can choose a parameter to link to it, so yes it should work for a filter. For other things like get data from file/folder where it combines two folders on the fly I would avoid that & use append instead
I like it, but you speak too fast for me as non English mother tongue
Sorry to hear that. It might help to change the speed of the video to 0.75x or something