Rolling

[VikramAdi]

Thanks 

[Greg_Deckler]

@VikramAdi Please provide sample data and expected output because I'm not understanding what you want.

[VikramAdi]

Thanks

[Greg_Deckler]

@VikramAdi As far as I can tell, the cumulative measure is returning correct results. Check out the table in the image. The cumulative measure is adding up the 30 day averages as it goes. So, the question becomes, what do you want the results to be? Because the cumulative measure is doing exactly what it is supposed to do. I attached the PBIX file below signature.

[VikramAdi]

Hi @Greg_Deckler , could you please check this query please.

[VikramAdi]

Thanks for your responce @Greg_Deckler ,

[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

[Greg_Deckler]

@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?

Better Rolling Average - Microsoft Power BI Community