• No Problem, I've been doing a lot with the new window functions especially the ranges for Running totals.

    I've also looked at DAX and found its missing some of the useful functions that exist in MDX, such as PeriodsToDate, ParallelPeriod etc, which make rolling averages so much easier.

    _________________________________________________________________________
    SSC Guide to Posting and Best Practices