Please note javascript is required for full website functionality.

Power Query Blogs

Power Query Blogs

Power Query: 10 Top Tips

19 September 2018

Welcome to our Power Query blog. This week, I take a look at some tips to help get the best out of Power Query.


Power Query: Good Relations

12 September 2018

Welcome to our Power Query blog. This week, I consider how to upload data from a relational database.


Power Query: Excellent Examples

5 September 2018

Welcome to our Power Query blog. July brought some improvements to Power Query/Get and Transform. I look at how creating a column from examples has developed.


Power Query: Words are Key

29 August 2018

Welcome to our Power Query blog. Last week’s blog looked at how to use list functionality to translate numerical grades into their letter equivalents. This week, I use another List() function to look for multiple keywords in columns of data.


Power Query: Upgrades

22 August 2018

Welcome to our Power Query blog. This week, I take a final look at an example where I need to translate numbers to letters in multiple columns, this time using the M function List.ReplaceMatchingItems() and matching those items using values from another table.


Power Query: Joining Grades

15 August 2018

Welcome to our Power Query blog. This week, I look at last week’s problem again, but this time I translate numbers to letters in multiple columns by joining tables.


Power Query: Upgrading Grades

8 August 2018

Welcome to our Power Query blog. This week, I look at an example where I need to translate numbers to letters in multiple columns using the M function List.ReplaceMatchingItems().


Power Query: Seating Plans

1 August 2018

Welcome to our Power Query blog. This week, I look at an example where I need to calculate the stock needed from a supplier.


Power Query: Technically Dating

25 July 2018

Welcome to our Power Query blog. This week, I look at some useful logical M functions to convert data into dates or vice versa.


Power Query: Currently Dating?

18 July 2018

Welcome to our Power Query blog. This week, I look at some useful logical M functions to determine whether a date is in a particular period.


Newsletter