Before an analyst can start analyzing the data, first it is necessary to know whether the data is up-to-date or not. There are (at least) two pieces of …
[Weiterlesen...] Infos zum Plugin Let your users know how up-to-date their data is
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.
Fast table construction with Table.FromColumns and lists with metadata records
One of the fastest methods I know to create tables in Power Query/ M is the function Table.FromColumns(), which takes a list of lists and creates a table from …
3 ways for sums over columns in Power Query
Normally I calculate sums in Power Query over rows. Recently, however, I was given the task of calculating sums over columns. I wrote a German-language post …
[Weiterlesen...] Infos zum Plugin 3 ways for sums over columns in Power Query
How to handle custom errors in M gracefully
I can recall that back then, in the good old Excel VBA days, at some point, I was very busy with error handling to make it easier for the user to understand the …
[Weiterlesen...] Infos zum Plugin How to handle custom errors in M gracefully
How does the filter context in DAX apply?
If you deal with Time Intelligence functions (TI) in DAX, you quickly reach the point where you can no longer use the standard TI functions. Very quickly you …
[Weiterlesen...] Infos zum Plugin How does the filter context in DAX apply?
Table.Profile and its unknown second parameter
A couple of weeks ago I could finally publish my post about tables in M - how, when and why. Under "Other special table functions" I mentioned the function …
[Weiterlesen...] Infos zum Plugin Table.Profile and its unknown second parameter
Tables in Power Query – how, when and why
The M language has so-called structured values, to which lists, records and tables belong. Each value type serves specific purposes and this post is intended to …
[Weiterlesen...] Infos zum Plugin Tables in Power Query – how, when and why
Pitfalls with Table.ColumnsOfType
I recently came across a behavior of the Table.ColumnsOfType() function that I want to share with you today. Since this post talks about ascribed types in M, I …
[Weiterlesen...] Infos zum Plugin Pitfalls with Table.ColumnsOfType
How to identify Measures not used in your pbix file
WARINING: Due to a broken DMV in Power BI Desktop, that I use for this solution, we cannot use this tool anymore, until until Microsoft fixes the issue. Sorry …
[Weiterlesen...] Infos zum Plugin How to identify Measures not used in your pbix file
Ascribed types in M: why to generally avoid them
I recently stumbled across the topic 'ascribed types' in M after a while and had a very informative conversation with the Power Query dev team about it. In this …
[Weiterlesen...] Infos zum Plugin Ascribed types in M: why to generally avoid them