This week, I look at the M function List.Accumulate and its uses where the seed is not zero.

This week, I look at simple examples of how to use the M function List.Accumulate...

This week, I look at how to transform extracted data into a useful table.

This week, I take a look at how extracting data from multiple lists can be confusing when nulls are involved.

Welcome to our Power Query blog. This week, I take a look at how to pass Excel data as a parameter in Power Query.

Welcome to our Power Query blog. This week, I take another look at what I can do with Excel.CurrentWorkbook.

This week, I take a look at the latest improvements to the ‘Add Column from Examples’ functionality...

Welcome to our Power Query blog. This week, I take a look at how to reference a cell in an Excel workbook from Power Query.

Previously I looked at a few ways to share queries between workbooks. This week, I take a look at a slightly different approach...

Welcome to our Power Query blog. This week, I take a look at a way to create and append new queries by starting with the Query Editor.