Speed up Power BI development time with filters and parameters

In this video Mitchell discusses how to speed up development time in Power BI by adding filters, using parameters and taking advantage of query folding. All of this is done inside the Power Query Editor within Power BI Desktop!
👍 If you enjoy this video and are interested in formal training on Power BI, Power Apps, Azure, or other Microsoft products you can use my code "Mitchell30" at check out when purchasing our On-Demand Learning classes to get an extra 30% off - pragmaticworks...
-- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - - - - - - - - - - - - - - -
Next step on your journey:
👉 On-Demand Learning - Start With The FREE Community Plan: tinyurl.com/2u...
🔗Pragmatic Works On-Demand Learning Packages: pragmaticworks...
🔗Pragmatic Works Boot Camps: pragmaticworks...
🔗Pragmatic Works Hackathons: pragmaticworks...
🔗Pragmatic Works Virtual Mentoring: pragmaticworks...
🔗Pragmatic Works Enterprise Private Training: pragmaticworks...
🔗Pragmatic Works Blog: blog.pragmaticw...
Let's connect:
✔️Twitter: / pragmaticworks
✔️Facebook: / pragmaticworks
✔️Instagram: / pragmatic.works
✔️LinkedIn: / pragmaticworks
✔️UA-cam: / pragmaticworks
Pragmatic Works
7175 Hwy 17, Suite 2 Fleming Island, FL 32003
Phone: [phone]
Email: [e-mail]
#PragmaticWorks

[@furkansimsek33]

Thank you for the tip. I am looking forward to learning more Power BI tips from Pragmatic Works :)

[@lucasimonebernardini6922]

good tutorial. thanks
Is there a similar way to filter diagrams or charts as well ?

[@seanguerrero1187]

Thanks for sharing this great tip, Mitchell! Will this also help in reducing the lag time it takes in creating/editing measures since now there would be less data to work with?

[@jhormangomez2268]

Totally agreed, also common sense

[@kebincui]

Great tip👍. Thanks

[@shoaibrehman9988]

Yes indeed its gr8 tip.

[@manuelmunoz357]

Mitchell, thanks for this very useful tip. I find parameters to be a great tool but I noticed that coding the date at the parameter level minimizes the number of instances where to update a date change in the future, however, it still creates a dependency on the user to remember in the future to change the base date used to filter the dataset. Would it be possible to create a dynamic parameter that would use a formula such as > the previous 12 months, etc.? If so, could you show us how to do it? Thanks!

[@kebincui]

hi Mamuel, you can create a parameter (e.g. MonthsBackParameter of how many previous months you want the data to be filtered and then you use the code below to get the data filtered dynamically:
= Table.SelectRows( #"Previous Step", each [Your Date Column] >= Date.StartOfMonth(Date.AddMonths(DateTime.Date(DateTime.LocalNow()), - (MonthsBackParameter-1) )))