Power Query – Running Total

In this post, I want to cover a common reporting requirement, which is a Power Query running total.  I have previously covered a similar topic in a post about running totals in tables; however, those methods don’t work in Power Query.  So, we’ll need to find an alternative approach. Both Tables and Power Query were … Read more

Power Query – Tips and Tricks

Power Query - Top Tips

It’s now time to bring this Power Query series to a close.  And where better place to end than with some tips and tricks to help you to succeed. Change the default Close & Load options Power Query’s default Close & Load options assume we want to load the data into an Excel table.  As … Read more