Rename a Query and Standard Function

We can rename the query or table inside the power query editor, to make the table name more helpful. And Utilize the Standard functions in order to do some standard calculation on thee column.

1. Rename a query

It is good practice to change uncommon or unhelpful query names to names that are more obvious or that the user is more familiar with. The query name will determine the model table name.

Note: Naming conventions for tables, columns, and values have no fixed rules.

Method 1: In Power Query Editor, in the Queries pane to the left of our data, select the query that we want to rename. Right-click on the query and select Rename. Edit the current name or type a new name, and then press Enter.

Method 2: Double-click on the query whose name we want to change, in the Queries Pane and rename it.

Method 3: In the Queries pane, select the query. And then in the Query Settings pane, in the Name box type the new name of the query and press Enter.

In the Queries pane, verify that the query name has updated.

2. Standard Function

Path 1: To multiply the column values by 100:
Step 1: Select the column header, and then on the Transform ribbon tab, from inside the Number Column group, click Standard, and then select Multiply.

Step 2: Enter the Value and click on Ok.

Step 3: The resultant column is shown in the image below. Here, all the values of the column are multiplied by 100.

Note: Here it modifies the existing column.

Path 2: To multiply the column values by 100:
Step 1: Select the column header, and then on the Add Column ribbon tab, from inside the From Number group, click Standard, and then select Multiply.

Step 2: Enter the Value and click on Ok.

Step 3: A new column is added in the table, as shown in the following image.

Note: The difference in Path 1 and Path 2 is, Path 1 modifies the current column in the query and Path 2 adds a new column to the query.