fbpx
[email protected] +1 203-349-9909 / +91-8080042523

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 */’.

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.

 LOAD DATA IN POWER QUERY

Step 2: Open Advanced Editor

To open Advanced Editor in Power Query click on

Home  >  Advanced Editor

OPEN ADVANCED EDITOR

BECOME A DATA ANALYST COURSE
• Power BI • Advanced Excel • Excel Dashboard • Excel VBA • SQL Programming Language • SAS Programming • many more

 

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.

ADD COMMENTS IN M

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.

DATA TABLE AFTER MERGING COLUMNS

You can learn more :