Calendar-based time intelligence still needs custom DAX
Built-in DAX time intelligence handles a standard Gregorian calendar fine, but custom fiscal years are another story. Where the built-in functions stop helping, and how a row rank column took one client’s moving average from 500ms to 110ms.