Aged Debtors-Dynamic Banding in DAX

Having hit the P&L and Cash Flow in previous posts, it seems only reasonable to move on to Balance Sheet aspects. The die-hard "non-accountant" Excel Pros and programmers amongst you are probably experiencing a sudden bout of Narcolepsy, but let me assure you that this gives us the perfect opportunity to explore dynamic banding in DAX so please prop those matchsticks in place for the minute!

In this post, I'll construct a dynamic Aged Debtors report. This will calculate debt ageing values, showing outstanding debts by customer at user defined points in time.