Please note javascript is required for full website functionality.

Power Query Blogs

Power Query Blogs

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.


Power Query: Absolutely Fabulous

1 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: Exceptional Cases

24 April 2019

Welcome to our Power Query blog. Today, I am going to look at how to protect specific data when transforming text case.


Power Query: Files for Today

17 April 2019

Welcome to our Power Query blog. Today, I am going to select files using the date embedded in the file name.


Power Query: Interactive Query

10 April 2019

Welcome to our Power Query blog. This week, I look at how to make a functional query more interactive.


Power Query: Functional Query

3 April 2019

Welcome to our Power Query blog. This week, I look at how to make a query more functional.


Newsletter