Use Power Query Parameter to Quickly Filter

https://youtu.be/gFqlfSckc5s

This video will introduce you to using the parameter feature in Power Query. You can use parameter to pass values to other parts of your query to give interactivity to your query. This example will use a simple procedure of filtering a column to show how it works. Now filtering a column seems like overkill, but if you have a LOT of columns, scrolling across the many columns can be a hassle. Incorporating the parameter feature may make it less of a hassle.

Running Total in Power Query

https://youtu.be/PIxLdz7vjCM

Creating a running total in Excel is easy, really easy if you're an intermediate Excel user. Why then would we consider doing this in Power Query? Maybe it's a small part of a series of steps you're doing to clean up data. In that case you don't want to have a running total calculation outside of your Power Query steps. Unfortunately there is no Ribbon command in the Power Query editor to perform running totals. Don't worry, it's actually quite easy to do a running total in Power Query. It's just some M code and it's not even a lot.

Sharing Files with Power Query Parameter Feature

https://youtu.be/Br9xOuuqMFQ

When you are sharing Power Query files, it's usually not an issue to update and refresh your data. However if your source file and your file that is the final output for analysis are separate files, it becomes an issue. You're sending two separate files to your co-workers and expect this to work? Good luck, unless you have an easy way to make your links to the source file link. That could be done fairly easily with a parameter. Check out the video to see how you can make sharing Power Query files seamless.