Welcome to our Power Query blog. This week, I look at some useful Boolean Text() functions in M.

Welcome to our Power Query blog. This week, I look at an example where data comes in one Excel column and needs to be converted to a table.

Welcome to our Power Query blog. This week, I look at splitting data using a variety of delimiters.

Welcome to our Power Query blog. This week, I look at a more comprehensive method to convert a check box into a name.

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...