In Pivotal Pivoting, I showed how easy it was to pivot columns. When I pivoted my expense code column to show the amounts for each expense code, I had a table with lots of null values in it, as shown below. I am going to use this table to show how I can sum columns where some values are null...

In Power Query, explore the ‘Structured Column’ section on the ‘Transform’ tab, which is not available for most column types.

Power Query’s ability to efficiently transform data allows one to pivot (and unpivot) data at the touch of a button.

Last week, in In Terms of Conditional Columns, I looked at how parameters were a possible source when defining conditional columns. This week, I take a closer look at parameter creation by using a parameter in a filter...

Welcome to our Power Query blog. Today I take a closer look at conditional columns...

In Excel(lent) Functions, I covered how to replicate some commonly used Excel functions. Readers will recall that although Power Query is an add-on for Excel, it does not always work in the same way....

Today we look at how to join columns of data when the data type does not match.

Welcome to our Power Query blog. Today I look at how the Trim function in Power Query works, and how to make it better

Welcome to our Power Query blog. Today I look at dividing a full name column into first and last names.

When transforming data with Power Query, the most important skill is knowing where to start, and this week I look at one such scenario.