Please note javascript is required for full website functionality.

Power Query Blogs

Power Query Blogs

Power Query: More Fun with (Un)Pivot

18 December 2019

Welcome to our Power Query blog. This week, I look at another use for unpivoting.


Power Query: Fun with (Un)PivotTable

11 December 2019

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


Power Query: The Wrong Type

4 December 2019

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


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.


Newsletter