
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.
