With the current release of Power BI Desktop (September 2018), a feature is available that many Power Query fans have been waiting for for no less than 3 years: …
[Weiterlesen...] ÜberIntellisense for Power Query/ M – finally
Technical Topics
While all the other posts on this blog are in German, the Technical Topics are my way to contribute to the international Power BI community. The intention is to help others with these great tools and to learn myself from getting your comments. Enjoy.
Power BI history: From Designer Preview to Desktop June 18
The thing about hard drives is that you save a lot of files and then you don't look at them for years. I stumbled across a file from January 2015 these days: An …
[Weiterlesen...] ÜberPower BI history: From Designer Preview to Desktop June 18
Passing Filters to a Measure differently in DAX
Hi folks, I came across an unusual syntax for passing filters to a measure differently in DAX and want to share that with you. …
[Weiterlesen...] ÜberPassing Filters to a Measure differently in DAX
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 …
[Weiterlesen...] ÜberCustom 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 …
[Weiterlesen...] ÜberWriting 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 …
[Weiterlesen...] ÜberWriting 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 …
[Weiterlesen...] ÜberWriting documentation for custom M-functions, Part1
The Environment concept in M for Power Query and Power BI Desktop, Part 4
In our last post Imke and I discussed the environment concept in M on the basis of the native M function Expression.Evaluate(). This current post will cover …
[Weiterlesen...] ÜberThe Environment concept in M for Power Query and Power BI Desktop, Part 4
The Environment concept in M for Power Query and Power BI Desktop, Part 3
In our last post Imke and I discussed environments of nested records and let-expressions. The current post covers one native M function, which can define its …
[Weiterlesen...] ÜberThe Environment concept in M for Power Query and Power BI Desktop, Part 3
The Environment concept in M for Power Query and Power BI Desktop, Part 2
In our last post Imke and I startet to discuss the environment concept in M on the basis of a simple record and its sub-expressions. This current post will go a …
[Weiterlesen...] ÜberThe Environment concept in M for Power Query and Power BI Desktop, Part 2