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 …
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.
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...] ÜberHow 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...] ÜberAscribed types in M: why to generally avoid them
Records 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...] ÜberRecords in Power Query – how, when and why
Lists 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...] ÜberLists in Power Query – how, when and why
Join types in Power Query – SEE how it works
"Merge queries is one way to combine queries (or even different tables within the same query) in Power Query/M. This topic has already been extensively written …
[Weiterlesen...] ÜberJoin types in Power Query – SEE how it works
Query time periods with CUBE formulas in Excel
If your Excel file contains an Excel data model, you have the possibility to query this data model using so-called CUBE formulas within the Excel cells. This …
[Weiterlesen...] ÜberQuery time periods with CUBE formulas in Excel
Pivot shows values that are not part of the excel data model
I recently tried to help a customer who contacted me by phone with the following words: Lars, in my pivot data appear which are not contained in my Excel data …
[Weiterlesen...] ÜberPivot shows values that are not part of the excel data model
Culture codes in M functions
At the time of writing (October '18) there are 35 functions in M that accept a parameter called culture. The functionality of this parameter is relatively easy …
My personal Best of Power BI @ MS Ignite 2018
This is my personal Best of Twitter tweets regarding Power BI news from MS Ignite 2018. Thanks to all Ignite participants who shared their experiences with the …
[Weiterlesen...] ÜberMy personal Best of Power BI @ MS Ignite 2018