Forum Discussion
Rolling
8 Replies
VikramAdi Sorry, what do you mean by cumulative rolling 30 day average? Do you mean that 30 days ago just 1 day is displayed, 29, 2 days, 28, 3, etc?
Thanks for your responce Greg_Deckler ,
VikramAdi So like this?
Cumulative Measure = VAR __Date = MAX('Date'[Date]) VAR __Table = SUMMARIZE(FILTER(ALL('Dates'),[Date]<=__Date),[Date],"__30Avg",[Rolling 30 Days Average]) VAR __Result = SUMX(__Table,[__30Avg]) RETURN __Result
Thanks
VikramAdi Please provide sample data and expected output because I'm not understanding what you want.
Thanks
