Dynamic Filter by a Range of Values in Power Query

- - - - My Courses - - - -
✔️ Mastering DAX in Power BI -

✔️ Power Query Course-

✔️ Master Excel Step by Step-

✔️ Business Intelligence Dashboards-

- - - Blog - - -

[wayneedmondson]

Hi Chandeep. Excellent lesson! I like to try and solve before watching. Was able to generate the filtered results using List.Contains.. so.. must be learning something. Also, in watching your method, I realized that you can make the results return the opposite (all items not matching the filter) by changing =true to =false. Nice bonus lesson to understand how to take an action based on the results of the dynamic filter. Always good learning at Goodly! Thanks for sharing :)) Thumbs up!!

[Just-My-Opinion]

You explained exactly what I needed without adding unnecessary explanations. Thanks !

[aaronziebart]

This video made my life much simpler. Another tutorial overly complicated this dynamic filter with multiselect parameters. thanks a bunch!

[blairhall]

Fantastic! Helped me complete a task I've had on my plate for a while. Thanks!

[johannlotter]

Lovely straight forward explanation. Thanks

[MrDhunpagla]

Jaadu bhai Jaadu .... Awesome & super helpful 👍

[SuperDarekR]

As always. SUPER TRICKS. Thank you very much

[kimgraf]

Super helpful and powerful. Just what I needed!

[nileshhaval]

Nice video as usual, Would be really helpful..!

[djkujo]

Great video and explanation. You have a new subscriber. Thanks!

[KuldeepSingh-nqvi]

Hi Chandeep, your all videos are excellent, Thanks for creating such tutorials. I have one query, how to combine multiple queries into one using Table.combine function in power query dynamically. list should be picked from Excel Table.

[michaszymanski]

Thank you for your video. Let say I want to keep such filter but instead of adding all A, B, C etc I want to enter in this list all and is such case I want see all the values.

[TheAso]

Hi Chandeep, thank you very much for this excellent video, it's very helpful for me. However, I would like to add a specfic filter "ALL" in the list of filtered values in order to remove the filtered values and get my original list. Do you have an idea how to proceed please? Thank you very much for your help. Best Regards. Rajen

[hemant]

Hi chandeep...its a good way for small sets of data....on applying this formula on large datasets its time consuming....any idea if we can do it faster using list.buffer or table.buffer

[prashantpaygonde]

Thanks bro. really this is is very help full me.

[enricomendiola]

Hi Sir. Great video! Is it possible to create a video similar to this but filter a date range like start date and end date as criteria or parameter.

[MoonShine-bscl]

Hi your explanation is awesome, but if i want to apply a dynamic filter in power query on or before date of end of current month... Pls help

[Just-My-Opinion]

Hey I ran into an issue,
The query works form me. However it takes very long to finish loading after I hit refresh. It does eventually load but after 5+ min.
I do not have a lot of data. without this filter, the table loads in 15 secs.

[_rudolf.ganglbauer_]

Hi Chandeep! Great video as usual.
What do you think about an inner join?