Please note javascript is required for full website functionality.

Power Query Blogs

Power Query Blogs

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.


Power Query: Today’s Calendar

22 May 2019

Welcome to our Power Query blog. Today, I am going to look at how to use the calendar table to filter on the current day.


Power Query: Fascinating Filters

15 May 2019

Welcome to our Power Query blog. Today, I am going to look at how Power Query turns a tricky transformation into a simple task.


Power Query: Divide and Conquer

8 May 2019

Welcome to our Power Query blog. Today, I am going to look at a method to extract multiple columns from a single column of mixed data.


Newsletter