Ich durfte bei den letzten Virtuellen Power BI Days Hamburg als Speaker dabei sein und habe zum Thema "Lists, records und tables in M für Power Query in Power …
M
So verwendest Du geschriebene M-Funktionen in Power Query wieder
Häufig beginnt die Suche nach einer Problemlösung bei google. Das ist bei Power Query nicht anders, als bei allen anderen Bereichen. Solltest Du auf meinem Blog …
[Weiterlesen...] Infos zum Plugin So verwendest Du geschriebene M-Funktionen in Power Query wieder
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
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
Leserfrage: Umrechnung UTC-Zeit in lokale Zeit mit Power Query
Mich erreichte vor kurzem eine Leserfrage, in der es darum ging mittels Power Query eine Zeitangabe in UTC (koordinierte Weltzeit), in unsere lokale Zeit …
[Weiterlesen...] Infos zum Plugin Leserfrage: Umrechnung UTC-Zeit in lokale Zeit mit Power Query
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
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
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...] Infos zum Plugin Records 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...] Infos zum Plugin Lists in Power Query – how, when and why