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.
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 > Properties
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.
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.
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.
You can learn more :
- Steps to Create a-List Query From A Table Column
- How to Manage Parameters in Power Query
- Learn to Add Comments In M in Excel
- How to Display A Monospaced Font in Excel
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