Is there a way to comment M code / comment out lines or blocks of code?
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 )
The M stands for data Mash-up, as power query is all about connecting to various different data sources and “Mashing” them up. M code is the language behind the scenes of power query. When you create a data transformation in the power query editor UI, Excel is writing the corresponding M code for the query.
M supports two different types of comments:
= 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.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With