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

Add a custom column If you need more flexibility for adding new columns than the ones provided out of the box in Power Query, you can create your own custom column using the Power Query M formula ...

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

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.

Over the last few weeks, we have released lots of new Power Query & Dataflows features in Power Apps, enabling users to seamlessly bring their data into the Common Data Service – Here’s a recap of all ...

This guide describes how to reorder multiple columns in Power Query with Drag & Drop, without having to move each column individually.

The really mind-blowing tricks shown to me by the ever-helpful Curt Hagenlocher of the Power Query dev team will be covered in part 2. Let’s say you have a large csv file which contains a numeric ...

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