Power Query - leaving detailed notes of steps
Results 1 to 7 of 7

Thread: Power Query - leaving detailed notes of steps

  1. #1
    Board Regular
    Join Date
    May 2015
    Posts
    111
    Post Thanks / Like
    Mentioned
    3 Post(s)
    Tagged
    0 Thread(s)

    Default Power Query - leaving detailed notes of steps

    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!

  2. #2
    MrExcel MVP Ron Coderre's Avatar
    Join Date
    Jan 2009
    Location
    Boston, Massachusetts
    Posts
    2,287
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Power Query - leaving detailed notes of steps

    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?
    Best Regards,

    Ron Coderre
    Microsoft MVP-Excel (2006 - 2015)
    Using: Excel 2013 & 2016

  3. #3
    Board Regular
    Join Date
    May 2015
    Posts
    111
    Post Thanks / Like
    Mentioned
    3 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Power Query - leaving detailed notes of steps

    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!

  4. #4
    Board Regular alansidman's Avatar
    Join Date
    Feb 2007
    Location
    Steamboat Springs
    Posts
    4,883
    Post Thanks / Like
    Mentioned
    7 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Power Query - leaving detailed notes of steps

    @Fatso
    A really good beginner resource is "M is for (Data) Monkey" by Ken Puls and Miguel Escobar
    Let me know if that works for you
    Alan

    Am Yisrael Chai

    Win 10--Office 2019
    When Posting Code, please use code tags.
    How to insert Mcode to Power Query https://excel.solutions/2017/11/powe...te-code-video/


  5. #5
    Board Regular sandy666's Avatar
    Join Date
    Oct 2015
    Posts
    2,677
    Post Thanks / Like
    Mentioned
    27 Post(s)
    Tagged
    1 Thread(s)

    Cool Re: Power Query - leaving detailed notes of steps

    Find on MS site three pdfs:
    • Microsoft Power Query M Formula Language Specification
    • Power Query M Reference
    • What is Power Query
    Last edited by sandy666; Apr 4th, 2019 at 06:40 PM. Reason: added one more title
    I know you know but I forgot my Crystal Ball and don't know what you know



    In the first post, show the type of machine (PC / Mac) and the Office version you are working on
    impossible things we do on the spot. for miracles you need to wait for a while

  6. #6
    Board Regular
    Join Date
    May 2015
    Posts
    111
    Post Thanks / Like
    Mentioned
    3 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Power Query - leaving detailed notes of steps

    Thank you all for the suggestions! I'm excited to find out what I can do with Power Query!

  7. #7
    Rules violation
    Join Date
    Jan 2012
    Posts
    912
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Power Query - leaving detailed notes of steps

    Quote Originally Posted by Ron Coderre View Post
    // for single line comments
    /* for multi
    line comments */
    You can also add details in the query description, which you can get to via it's properties.

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •