Im letzten Beitrag habe ich darüber geschrieben was Funktionen eigentlich sind und wie Du Deine erste einfache benutzerdefinierte Funktion in Power Query/ M …
[Read more...] about Komplexere benutzerdefinierte Funktionen in Power Query schreiben
M
Wie Du benutzerdefinierte Funktionen in Power Query schreibst
Power Query hat eine Vielzahl nativer Funktionen zu bieten, die Dir das Leben erleichtern, doch das ist noch lange nicht alles. Es ist auch möglich eigene, …
[Read more...] about Wie Du benutzerdefinierte Funktionen in Power Query schreibst
Custom M function: GetTableOfDateAndDateTime
I am a huge fan of Power Query and the M language, but honestly I find it a bit inconvenient to create lists of date values or datetime values, using the …
[Read more...] about Custom M function: GetTableOfDateAndDateTime
Writing documentation for custom M-functions, Part3
In my two previous posts you could see how to add documentation to custom M functions in Power Query for Excel and Power BI Desktop. In the current post I …
[Read more...] about Writing documentation for custom M-functions, Part3
Writing documentation for custom M-functions, Part2
The good documentation of custom M functions is a key factor for efficiency in Power Query and Power BI Desktop. In my first post on this topic, I explained why …
[Read more...] about Writing documentation for custom M-functions, Part2
Writing documentation for custom M-functions, Part1
In a programming language such as M, with more than 630 functions, it is more than just useful if these functions are well documented. However, this also …
[Read more...] about Writing documentation for custom M-functions, Part1
Get your own Power Query Editor using Notepad++
Preface This post is not new. I published the first version on how to create your own Power Query Editor already in November 2015 on my old blog …
[Read more...] about Get your own Power Query Editor using Notepad++