Max of rolling average expression

Hi,

These measures work

TL = SUM('RPE/Wellness'[Training Load])

TL in previous week = CALCULATE([TL],DATESBETWEEN('Date'[Date],MIN('Date'[Date])-6,min('Date'[Date])))

7 day rolling average = if(ISBLANK([TL]),BLANK(),DIVIDE([TL in previous week],7))

All time high rolling average = if(ISBLANK([TL]),BLANK(),MAXX(ALL('Date'),[7 day rolling average]))

Also, to the visul, drag Date from the Date Table.

Hope this helps.

Hi big_ozzie1 

This time I totalled the Training Load for the last 7 days and divided it by 7.  (It appears to be what you were doing with your [7dayRA] only using a date table to account for missing dates.)

My RA = 
VAR _CurrDt = SELECTEDVALUE( 'Date'[Date] )
VAR _LastWk = _CurrDt - 7
VAR _SumOfLastWk =
    CALCULATE(
        [Total],
        FILTER(
            ALL( 'Date'[Date] ),
            'Date'[Date] > _LastWk
                && 'Date'[Date] <= _CurrDt
        )
    )
RETURN
    _SumOfLastWk / 7

(Note: Looking at rolling totals sorted descendingly seems to be counter-intuitive for me.  If it was me, I'd only look at the dates in a descending order AFTER I was convinced they worked in ascending order.  But that's just my opinion.)

pbix: Help - mine.pbix

Let me know how this goes.

(Also, my apologies to Ashish_Mathur  since I had came up with my solution last night I didn't see your almost identical solution. )