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.
Monday, January 9, 2023
Monday, December 19, 2022
Sharing Files with Power Query Parameter Feature
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.
Monday, December 12, 2022
Calculate Difference from Previous Row Excel & Power Query
When you’re compare period data like sales from one month to another, quite often you’ll want to know the difference between the months. In a standard Excel worksheet, this is super easy to do. When you get to a pivot table, also super easy but maybe not quite as intuitive...though it can still be done super easy. The same for Power Query, easy to do but not intuitive. Thanks for coming to this video because I’ll show you these three ways to do subtract value from a previous cell.
Subscribe to:
Posts (Atom)