Please note javascript is required for full website functionality.

Power Query Blogs

Power Query Blogs

Power Query: Functioning Columns

31 July 2019

Welcome to our Power Query blog. Today, I create a function to add a column to a table.


Power Query: Combining Forces

24 July 2019

Welcome to our Power Query blog. Today, I look at a way to reduce overheads when combining numerous files.


Power Query: Inquiring Minds

17 July 2019

Welcome to our Power Query blog. In a plot twist, today’s blog is about how Excel can make Power Query data easier to handle.


Power Query: Reliable References

10 July 2019

Welcome to our Power Query blog. Following on from last week’s look at duplicating and copying queries, today the topic considers referencing queries.


Power Query: Durable Duplicates

3 July 2019

Welcome to out Power Query blog. Today, I look at using ‘duplicate’ to replicate queries.


Power Query: Are Any of Them on the Table?

26 June 2019

Welcome to our Power Query blog. Today, I revisit the data I looked at last week to extend one of my solutions.


Power Query: Is it on the Table?

19 June 2019

Welcome to our Power Query blog. Today, I delve into the Table.Contains() M functions.


Power Query: Finding Fuzzy

12 June 2019

Welcome to our Power Query blog. After last week’s adventure in Power BI, I discover the fuzzy features of Excel Power Query.


Power Query: Fuzzy Matching

5 June 2019

Welcome to our Power Query blog. Today, I am going heading off into Power BI for a feature I’d like to see more of in Excel Power Query.


Power Query: Check Today’s Calendar

29 May 2019

Welcome to our Power Query blog. Today, I am going to look at an example which uses a calendar table to filter on today’s date.


Newsletter