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
Posts in Category ‘Excel’
Dynamic duration calculation using DAX in Power BI and Power Pivot
While it is fairly easy to calculate the difference between 2 dates in DAX using DATEDIFF, it is a bit more demanding if you want to exclude weekends and holidays (…) Read more
Import Measures from different Tabular Models using DAX Editor
Marco Russo has created a great tool for SSAS tabular that lets you edit measure definitions (which you should read here first if you haven’t done yet). In this article (…) 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