Please note javascript is required for full website functionality.

Power Query Blogs

Power Query Blogs

Power Query: Not Your Type

27 November 2019

Welcome to our Power Query blog. This week, I look at assigning types to columns.


Power Query: Time for a List

20 November 2019

Welcome to our Power Query blog. This week, we take a look at how list() functions can take you to a whole new dimension (time).


Power Query: Emerging from Merging

13 November 2019

Welcome to our Power Query blog. This week we look at extracting from merged Excel cells.


Power Query: Check the List

6 November 2019

Welcome to our Power Query blog. This week, we look at ‘remove error’ for lists.


Power Query: Learn by Example

30 October 2019

Welcome to our Power Query blog. Time for more on my favourite feature – Column From Examples.


Power Query: Python Go

23 October 2019

Welcome to our Power Query blog. Today, I look at how use Python to filter data in Power Query.


Power Query: Python Set

16 October 2019

Welcome to our Power Query blog. Today, I look at how to set up and use Python in Power BI.


Power Query: Python Ready

9 October 2019

Welcome to our Power Query blog. Today, I look at how to set up Python and make it available on Power BI.


Power Query: Top Tied

2 October 2019

Welcome to our Power Query blog. Today, I look at how to rank tied places.


Power Query: Grouping to the Max

25 September 2019

Welcome to our Power Query blog. Today, I look at groups and how to interrogate them.


Newsletter