Wishing my faithful readers peaceful and happy holidays. Hope you enjoy my jumping Power Query X-mas tree: It changes his size or decoration randomly every time you press refresh: Totally auto-M-agically 😉 (No (…) Read more
Posts in Category ‘Power Query’
How to store tables longer than 1,1 Mio rows in an Excel-sheet using Power Query and JSON
If you are working Power Query, you might come into a situation where you would like to make tables accessible from outside that file, that are longer than the 1,1 Mio rows (…) 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