This week, I look at a simple method to convert a check box into a name (next time I will move up a gear!).

This week, I look at what to do if you are short of memory.

This week I look at cross joins.

Whilst there are often multiple ways to achieve the same objective in Power Query, the purpose of today’s example is become familiar with the M function, Table.Join.

Welcome to our Power Query blog. This week, I look at how to use the List function to compare lists.

I have been looking at List functions in M language recently, and this one reminds me of my problems with null values in lists...

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.