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 ‘*/’.
Adding Comments In M With Power Query
Let’s take an example to see how it works.
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 Advanced Editor dialogue box as shown below. We have added the comment //Merge Columns to the Advanced Editor.
Step 4: Close & Apply
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