An article that demonstrates how to create a custom column in Power Query using the Power Query M formula language. If you need more flexibility for adding new columns than the ones provided out of ...

Note: the Power Query tools started off as an optional add-in for Excel version 2010 and 2013 before they became an integral part of Excel 2016 as the Get & Transform group of the Data Ribbon tab. The ...

This month we are enabling two of these capabilities in Power Query Online: “Add Column From Examples” and “Web By Example”. Add Column From Examples “Add Column From Examples” enables users to ...

Note: The Power Query tools started off as an optional add-in for Excel version 2010 and 2013 before they became an integral part of Excel 2016 as the Get and Transform group of the Data Ribbon tab.

In part 1 of this series – which I strongly recommend you read before reading this post – I showed how removing columns from a table can make a dramatic improvement to the performance of certain ...

A few weeks ago I wrote a post about comparing the contents of entire tables in Power Query, and a question came up in the comments about how you might go about comparing values in columns rather than ...

With Power Query, you can add a conditional column to your query by defining IF-THEN-ELSE conditions in your query. When the conditions are fulfilled, the conditional column automatically displays the ...