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
Posts in Category ‘DAX’
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