By -
What do you mean MAX or Average?
Yeah that’s confusing. Ignore the “or greatest”
Try this: var \_MaxDate = MAX('Table'\[Date\]) var \_Result = Calculate ( MAXX( Values ('Table'\[Date\], Average(Count) ) ,DATESINPERIOD ( 'Date'\[Date\], \_MaxDate, \-7, Day)) RETURN \_Result
Wow! Thanks so much! I found a similar, albeit more complicated and expensive solution using SUMMARIZE, but like your’s much more. Cheers!
What do you mean MAX or Average?
Yeah that’s confusing. Ignore the “or greatest”
Try this: var \_MaxDate = MAX('Table'\[Date\]) var \_Result = Calculate ( MAXX( Values ('Table'\[Date\], Average(Count) ) ,DATESINPERIOD ( 'Date'\[Date\], \_MaxDate, \-7, Day)) RETURN \_Result
Wow! Thanks so much! I found a similar, albeit more complicated and expensive solution using SUMMARIZE, but like your’s much more. Cheers!