Please note javascript is required for full website functionality.

Power Query Blogs

Power Query Blogs

Power Query: Heading Off – Part 1

14 February 2024

Welcome to our Power Query blog. Today, I begin to look at an issue that occurs when I load to a Table with no headers.


Power Query: Equal Split Part 5

7 February 2024

Welcome to our Power Query blog. Today, I continue to modify the solution to divide amounts over rows by using a parameter.


Power Query: Equal Split Part 4

31 January 2024

Welcome to our Power Query blog. Today, I modify the solution to divide amounts over rows by using a parameter.


Power Query: Equal Split Part 3

24 January 2024

Welcome to our Power Query blog. Today, I look at a slightly different problem where I need to divide amounts over rows.


Power Query: Equal Split Part 2

17 January 2024

Welcome to our Power Query blog. Today, I refine a solution to a problem where I need to divide amounts over rows.


Power Query: Equal Split

10 January 2024

Welcome to our Power Query blog. Today, I look at a problem where I need to divide amounts over two rows.


Power Query: Blog List – Part 6

3 January 2024

Welcome to our Power Query blog. I would like to get a list of all the Power Query blogs I have posted. Today, I welcome some new functionality, currently in Preview, which will allow me to achieve my goal in Power Query in Excel.


Power Query: Blog List – Part 5

27 December 2023

Welcome to our Power Query blog. I would like to get a list of all the Power Query blogs I have posted. Today, I look at why the method I used required Power Query in Power BI.


Power Query: Blog List – Part 4

20 December 2023

Welcome to our Power Query blog. I would like to get a list of all the Power Query blogs I have posted. Today, I improve the query to extract data from all pages by extracting the last page number from the data.


Power Query: Blog List – Part 3

13 December 2023

Welcome to our Power Query blog. I would like to get a list of all the Power Query blogs I have posted. Today, I continue to extend the query to extract data from all pages.


Newsletter