Power Query Blogs

Power Query: Dynamic Removals

4 March 2020

Welcome to our Power Query blog. This week, I look at how to remove columns without referencing column names.

26 February 2020

Welcome to our Power Query blog. This week, I look at yet another solution to my “February problem” referencing other rows.

19 February 2020

Welcome to our Power Query blog. This week, I look at another solution to last week’s problem referencing other rows.

12 February 2020

Welcome to our Power Query blog. This week, I look at referencing other rows.

5 February 2020

Welcome to our Power Query blog. This week, I look at filling issues.

29 January 2020

Welcome to our Power Query blog. This week, I look at sorting issues.

22 January 2020

Welcome to our Power Query blog. This week, I look at a common problem in Finance – performing that pesky bank reconciliation!

15 January 2020

Welcome to our Power Query blog. This week, I look at using some M functions on grouped data.

8 January 2020

Welcome to our Power Query blog. This week, I look at a use for grouping.

1 January 2020

Welcome to our Power Query blog. This week, I look at a common problem.