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 appreciated
Solved! Go to Solution.
@ryan_mayu I can't provide the sample data, but maybe I can clarify a bit more.
Each row of my data is assigned a "season" (a year) and I would eventually like to calculate a rolling average over the "seasons". However, I need to use the final data for each season, which is associated with a particular date - the MAX of "date_closed". Final data is the accumulation of all data up until the latest date in each season.
If the MAX date of "Season" 2020 is 4/1/2020, all rows with 2020 as the season must show 4/1/2020 as the final date (in a column)