How do I comment in Power Query M?

Chris picture Chris · Jul 22, 2015 · Viewed 24.7k times · Source

Is there a way to comment M code / comment out lines or blocks of code?

Answer

Alejandro Lopez-Lago - MSFT picture Alejandro Lopez-Lago - MSFT · Jul 22, 2015

M supports two different types of comments:

  • Single line comments can be started with //
  • You can comment out multiple lines or comment out text in the middle of a line using /* */ (e.g. = 1 + /* some comment */ 2)

Comments might seem to disappear in the formula bar if they are at the end of the line, but they are still there. You can verify this by looking at your code in the Advanced Editor.