I decide turn all my function keywords in deep blue and bold letter. Then press Styler and style the keywords as you like it.
Mark everything in Excel (ctrl + a), then copy (ctrl + c), move to 1st Group in Notepad++ and paste all the function into that box (ctrl + v). Go there and click the link list of functions for keywords highlighting ). Go to tab Keywords Lists and fill the first group with all the functions from Power Query (Click this link to get to my personal blog, where I provide this list of functions for you). Now you have to define special keywords and their styles. Choose Create New… and give your language a name. The form for defining the user defined language opens. Go to Language and choose Define your language…
#XML NOTEPAD 2015 SOFTWARE#
I installed the first version („ Take this one if you have no idea which one you should take„) on my machine.Ģ. Creating Keywords highlighting via the GUI of Notepad++Īfter you installed the software you need to do some modification in Notepad++. Of cause you need to download the free tool Notepad++ (e.
#XML NOTEPAD 2015 CODE#
It is completely FREE and will take your M Code to the next level
#XML NOTEPAD 2015 HOW TO#
If you are dealing with these scenarios as well and you find my solution interesting, please read further and learn how to get it. Commenting becomes more important, the longer and complex your M code gets. Syntax highlighting helps to keep (or get) an overview over your M code. Scenario 2: Taking a look at M code with highlighted keywords and comments Especially the help texts help you to get more familiar with the M language. Using the editor makes it much easier to find the function that fits your needs. Scenario 1: Finding the right function for my problem This is why I was investigating a bit and found a solution, which I hope will be helping others as well. The number of Power Query functions are getting more every month and I am always looking for the right function for my specific problem. What I was still missing was parameter hints and help texts. Matt’s tool already had intellisense and syntax highlighting. At that time I did not even know that it was possible to create a custom language in Notepad++. He showed how to create an editor for Power Query with Notepad++. Matt is a Senior Program Manager at Microsoft and member of the Power BI Developer Team. In 2015 I read the following article, written by Matt Masson. The fact, that M is case sensitive doesn’t make it easier at all. The Power Query Advanced Editor comes without intellisense (auto completion), no parameter hints, no syntax highlighting, no help texts, which explain what the functions do, no nothing.
Many of you know that Power Query is an amazing tool for data import and data transformation.
0 kommentar(er)
