If you use DAX to flatten Parent-Child hierarchies you will end up with a table that has a static number of columns (like described here). If you need a dynamic (…) Read more
Posts in Category ‘DAX’
Comfort Functions for Easy Profit & Loss statements in Power BI and Excel – Part2
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
Easy Profit & Loss (and other account) statements in PowerBI and Excel – Part2
Welcome to part 2 of my series of easy Profit & Loss and other account statements in Power BI and Excel. In the first part I introduced the general principle (…) Read more
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
Analyzing events with a duration in DAX – further simplification
Alberto Ferrari has recently published a very smart concept how to analyze events with a duration in DAX, which you should read here, if you haven’t done yet. It simplifies (…) Read more