max
1 Topic
Need to return single date for each year for rolling average measure
Hi everyone, I'm looking to calculate a rolling average, but first I need the date in which it will calculate over. My dataset currently contains 19 years worth of information, each identified with a "Season" (ex: 2021, 2022, etc). I need to identify the last date ("date_closed") of each season. So far, I've tried some measures combining MAX(date_closed) & FILTER for "Season", but I haven't gotten what I want I get my result in Excel, but I'm not too versed in DAX yet. Any help is appreciatedSolved1.6KViews0likes5Comments