How to Add Comments In M Using Power Query

You can add comments to your code either with single-line comments that start with ‘//’ or multi-line comments that start with ‘/*’ and end with ‘*/’. Comment plays an important role to understand the code. In the future, if you want to change some part of code or want to share your code with your friend, who can easily understand code without your help then comment in code is important.

There are many Power Query Tips & Tricks that used to transform and clean your data. You can learn other Power Query Tricks at our Power Query Online Training Program. Join today and become a Power Query Expert. 

Adding Comments In M With Power Query

Let’s take an example to see how it works.

• Step 1: Load Data in Power Query
• Step 2: Open Advanced Editor
• Step 3: Add Comments in M
• Step 4: Close & Apply

Step 1: Load Data in Power Query

Load the data in Power Query first to apply comments in M as shown below. Perform some action to the data table loaded in Power Query. Here we have merged the columns.

Step 2: Open Advanced Editor

To open Advanced Editor in Power Query click on

Home  >  Advanced Editor

Step 3: Add Comments in M

Add a single comment to the query for merging columns in the Advanced Editor dialogue box as shown below. We have added the comment //Merge Columns to the Advanced Editor.

Step 4: Close & Apply

The picture below shows the data table after merging the columns and adding comments in Query Editor. Now you can close and apply the changes.

You can learn more : 

• Steps to do Comments In Query Steps
• Steps to Creating A-List Query From A Table Column
• How to Display A Monospaced Font in Power Query
• Delete Steps Until End Using Power Query