April 21, 2022
Remove Blank Rows and Columns from Tables in Power Query
When you import data to Power Query, it's not unusual to end up with a table containing blank rows and
Read More
November 11, 2021
Remove Text Between Delimiters – Power Query
This is my source data and I want to remove the percentages Specifically I want to remove all occurrences of
Read More
October 7, 2020
Grouped Running Totals in Power Query
In a previous post I looked at creating running totals in Power Query, here I'll be creating grouped running totals.
Read More
September 24, 2020
Quickly Create Running Totals in Power Query
A running total (or cumulative sum) is when you add the previous value to the next, basically you're summing values
Read More
September 3, 2020
Power Query Custom Functions
If you're familiar with using Excel functions (and of course you should be) then you'll know that a function typically
Read More