With Power Query, you can add an Index or Custom (you define the formula) column to your current query.

Use Excel's Get & Transform (Power Query) experience to add new columns of data in the Query Editor by simply providing one or more sample values for your new column.

You load a query to a Data Model by using the Load To command to display the Import Data dialog box, and then selecting the Add this data to the Data Mode l check box.

With Power Query, you can merge two or more columns in your query. You can merge columns to replace them with a merged column, or create a new merged column alongside the columns …

With Power Query, you can add a conditional column to your query. You can define IF-THEN-ELSE conditions in your query. When the conditions are fulfilled, the conditional column will …

To do this, write a formula in Power Query's formula builder. Power Query formulas are similar to Excel formulas. Select Add Column > Custom Column. Enter "Bonus" in the New column …

Many ways to add a column based on its data type: determine if a number is odd or even, lowercase a text string, or display the month name of a date/time.

There may be times when you want to modify or create a formula. Formulas use the Power Query Formula Language, which you can use to build both simple and complex expressions. For …

A merge query creates a new query from two existing queries. One query result contains all columns from a primary table, with one column serving as a single column containing a …

In this tutorial, you can use Power Query's Query Editor to import data from a local Excel file that contains product information and from an OData feed that contains product order information.