Need Help? Chat with us
[email protected] +1 203-349-9909 / +91-8080042523

Top 5 Steps to do Comments In Query Steps

The new feature of Power Query allows you to add descriptions to each step in the Applied Steps pane. The step descriptions become comments in the M code in Power Query. If you write M code in the Advanced Editor window, then your comments appear as descriptions in the Applied Steps pane.

Comments In Query Steps With Power Query

Let’s understand this feature along with an example.

Here, we have a data table for sales and we have changed the data type of the columns. If you want to highlight the changes made to the data table, add comments in query steps. You can easily do it by following below steps.

Step 1: Change Data Type

Change the data type of every column according to the data it holds. To change data type click on the left side of the column header and choose any one option that is relevant to your data.

 DATA TABLE AFTER CHANGING DATA TYPE

 Step 2: Add Comments to Steps

Comments are added to steps to describe the action performed. To add comments to steps, go to-

Applied Steps  >  Right Click on Step  >  PropertiesADD COMMENTS TO STEPS

Step 3: Adding description in Step Properties

When you click on Properties option, a Step Properties window gets open. In this window, you can edit both, the name of step as well as the description and click OK to apply as shown below.

ADDING DESCRIPTION IN STEP PROPERTIES

Step 4: Hover on Steps to view comments

You can view these comments in Applied Steps pane by hovering the mouse on the steps for which you have added comments. You can also change the step name as shown in the below picture.

BEFORE ADDING COMMENTS TO STEPS

Step 5: Open Advanced Editor to check the comment added

You can also view this comment in the Advanced Editor window as shown in below picture.

VIEW COMMENTS IN ADVANCED EDITOR

You can learn more :

Leave a Reply

1 Response