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

To reorder multiple columns in Power Query with Drag & Drop, you have to follow these steps: Let us say we have a sample data source as shown in the screenshot below. So the first thing we need to ...

We can add another dimension to our counting. For instance, drag the “Age” column into the empty “Columns” area to add more detail to the table by counting the number of descriptions by each age. You ...

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

Adding an index column in Power BI. To make this work, we must add a new column and populate it with the right values. Specifically, we’ll run a query that will add an index column.

Add a column using Power Query. Select Edit Queries. This will open a new window in Power BI. Go to the Add Column tab. Add an Index Column and name it Index. Add a Custom Column with this expression: ...

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