NEW! FREE 45 Minutes Excel VBA Loop Course for Beginners Watch now 

Power BITutorials

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

2 Mins read

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.

 

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 :

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

Related posts
Power BITutorials

Opportunity Analysis Power BI Dashboard

1 Mins read
Information: A software company that has two sales channels: direct and partner. The sales manager created this dashboard to track opportunities and…
Power BITutorials

Procurement Analysis Power BI Dashboard

1 Mins read
Information: It analyzes a manufacturing company’s spending on vendors by category and location. we explore these areas: Who the top vendors are…
Power BITutorials

Retail Analysis Power BI Dashboard

1 Mins read
Information: It analyzes retail sales data of items sold across multiple stores and districts The metrics compare this year’s performance to last…