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

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

Here’s something that will excite all you M nerds out there! Did you know you can make tooltips appear when you hover over column headers in a table in the Power Query Editor in either Power BI ...

If you want to add a column from another table in Power BI, first add a column when there is a relationship between tables, then use Power Query.

Quite often, in Power Query, you want to ‘nest’ calculations and transformations – apply them not across the whole table, but repeat the same calculation or transformation across multiple groups of ...

Want to perform powerful data analysis and create complex data models in a spreadsheet? Learn how to use the Power Pivot feature in Excel.

Today, we released eight data transformation and connectivity updates for Get & Transform—a powerful set of Excel 2016 features based on the Power Query technology, which provides fast, easy data ...

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