Power Query - leaving detailed notes of steps

Factotum

Board Regular
Joined
May 14, 2015
Messages
118
Does anyone know of a way to keep notes on what each step does in Power Query? When I write VBA, I write up a detailed explanation of what each line of code does so if anyone needs to modify it they can understand the method to my madness. The closest options I can find in Power Query are:
  1. Rename the steps which doesn't have a lot of space
  2. Right click on the step, go down to Properties, and enter my notes in the Description box

I'm guessing option 2 is my best bet, I'm just used to being able to see my notes without having to click through menu options. Or is there any standard in this area that's generally considered a best practice? Thanks for any ideas!
 

Excel Facts

Square and cube roots
The =SQRT(25) is a square root. For a cube root, use =125^(1/3). For a fourth root, use =625^(1/4).
I open the Advanced Editor and put my comments there.

// for single line comments

/* for multi
line comments */

Is that something you can work with?
 
Upvote 0
That's a fantastic idea on several levels. It gives me what I was asking for as far as comments/notes, but it might also help me learn Power Query better. I learned VBA mostly from the marco recorder and then reverse engineering the code it created. The Advanced Editor could maybe provide that same benefit. I'm very new to Power Query and the only one in my organization making an attempt to learn it. It could have massive benefits to my team if I could just get a little better with it. Thank you for your help!
 
Upvote 0
Find on MS site three pdfs:
  • Microsoft Power Query M Formula Language Specification
  • Power Query M Reference
  • What is Power Query
 
Last edited:
Upvote 0

Forum statistics

Threads
1,213,484
Messages
6,113,924
Members
448,533
Latest member
thietbibeboiwasaco

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top