topic Re: Rolling in DAX Commands and Tips

Rolling

VikramAdi — Wed, 08 Mar 2023 13:48:45 GMT

Re: Rolling

Greg_Deckler — Fri, 03 Mar 2023 20:19:00 GMT

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

Re: Rolling

VikramAdi — Wed, 08 Mar 2023 13:50:35 GMT

Thanks for your responce Greg_Deckler ,

Re: Rolling

Greg_Deckler — Sun, 05 Mar 2023 15:15:14 GMT

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

Re: Rolling

VikramAdi — Wed, 08 Mar 2023 13:51:02 GMT

Thanks

Re: Rolling

Greg_Deckler — Mon, 06 Mar 2023 14:24:42 GMT

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

Re: Rolling

VikramAdi — Wed, 08 Mar 2023 13:51:46 GMT

Thanks

Re: Rolling

VikramAdi — Tue, 07 Mar 2023 03:15:43 GMT

Hi Greg_Deckler , could you please check this query please.

Re: Rolling

Greg_Deckler — Tue, 07 Mar 2023 14:59:46 GMT

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.