fbpx

Top 5 Steps to do Comments In Query Steps – Power Query Tutorial

Learn How to do Comments in Query Steps with Power Query. 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.

Want to Master Power Query? Start your Power Query Training Today and become a master in a few days.  

Comments In Query Steps With Power Query

Let’s understand this feature along with an example.

MICROSOFT POWER QUERY FOR BEGINNERS
• Course Certificate • Lifetime Access & Free Updates • Lifetime Support • Career Focused

 

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

MICROSOFT POWER QUERY TRAINING
• 100+ Video Tutorials • 15 Case Studies • 2 eBooks • 10 Presentation Decks • 2 Webinar • 24*7 Dedicated Support

 

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 :

Conclusion:

In this blog, we will learn about How to Comments In Query Steps With Power Query

Step-by-Step to Comments in Query

Step 1: Change the Data Type
Step 2: Add Comments to steps
Step 3: Adding description in Step Properties
Step 4: Hover on Steps to view comments
Step 5: Open Advanced Editor to check the comment added