Here comes some long awaited comfort functions for part 2 of my easy P&L series. In the first section I’ve presented the general principle on how to work with a (…) Read more
Posts Tagged ‘PowerBI’
Dynamic & bulk type transformation in Power Query, Power BI and M
This is just a quick code-share-of-the-day of different scenarios for dynamic type transformation of multiple columns at once. The syntax to transform the format of 2 columns (“Column1” and “Column2”) in (…) Read more
How to tame Case Sensitivity in Power Query and PowerBI
Have you heard of “Comparer.OrdinalIgnoreCase”? If the answer is “No” (or something similar), you will be very delighted to hear that this is your key to disable case sensitivity in comparing operations. (…) Read more
Easy Profit and Loss and other (account) scheme reports in Power BI and Power Pivot using DAX
This is about an easy way to create typical finance reports like Profit and Loss using DAX that (unlike all other solutions I’ve come across so far) can be handled with (…) Read more
Advanced type detection in Power BI and Power Query: Table.ClassifyMixedColumnTypes
This is not a proper blogpost, just a quick share of a function I’ve created today which I think will be very useful for others as well: Automatic type detection will (…) Read more
How to analyse M-functions step-by-step?
This is a quick tutorial on how to analyse M-functions step-by-step. Queries, that have been transformed into a function (1) can be invoked in the query-editor (2) and they will then return (…) Read more