Calculate a Rolling Average in Power BI Using DAX 

I hope you enjoyed this tutorial 😃 If you did please give it a LIKE... and don’t forget to SUBSCRIBE for even more content! For More 👉 ru-vid.com

You get a subscription for this! Exactly what I needed minus the fluff that I have found in other tutorials. Excellent stuff!

This is great, easy to understand, simple and concise 👍👍

Thank you -- good example!

Thanks for sharing . Amazing

Thank you!🙏🏻

Amazing 👏

Thank you!

thx saved me!

Thank You So much for the insight given to us through your tube channel. 🙏

Thank you so much!!! 😃

Thank you for that 👍

How do i do rolling avg of months. while the month rage will be selected from slicer So i select july 2020 to date and i get rolling avg of amount

How can I keep the rolling average for 1st entry the same as 'Amount' and then start calculating the average for the second entry as Rolling sum/2, for third entry as rolling sum/3 and so on....

in this example if i want to exclude the weekends how can i do?

thanks 👍

Are you also able to calculate the correct amount the first 7 or 28 days?

Hey!! The solution and approach looks great! But the drawback of this approach is this would not give proper average if the dates aren't continuous i.e. if the sales data for a few days are missing in the data. The formula would sum up properly until 7 days, but you cannot divide this sum by 7 as the number of entries considered are not 7 in case of missing data.

Trying to calculate the 12 month rolling average for a rate (Measure). It doesn't seem to be working and is just returning the same value as the current month's value (not the average of the last 12 months).

How would I do a rolling 7 days Calculation if I were to combine it with a Filter formula? For example Measure Name = VAR NumDays = 7 VAR RollingCOUNT = CALCULATE( COUNT ( 'table'[ColumnName],FILTER(table,'table'[column]="Value") DATESINPERIOD( table[Date],LASTDATE(table[Date]),-Numdays,DAY) ) RETURN RollingSum

I was struggling to achieve the same result by experimenting with AVERAGEX... It's brilliant how a simple divide by RollingPeriod helped! Many thanks! Subscribed!

It's a great video. My question is whether I can calculate the trailing average for the Measure I created.

I wish you would zoom in on the formula ... it's super blurry on my view and very difficult to read the text in the rolling average measure.

I'm trying to do this but with number of visits my field team does. Instead of "Sum[Total Sales]" I do "DistinctCount[VisitID]" but when I drop the Moving Average measure into my line chart, it looks exactly the same as if I would drop the [VisitID] column into it. No average is being calculated. It just shows the daily visits. What am I missing?

I don’t seem to fully understand how LASTDATE works in this formula. I know LASTDATE returns a table with one row and colum of the last date of the specified column date. I’m this example the last date is July 23rd. The calculate function will run whatever function we specified for each row. So how is it the each row isn’t just based on July 23rd? Or is it the LASTDATE is based on the last date for the specific row it’s evaluating at a specific point in time. So when it’s evaluating row 1, the Last date is July 1 bc it hasn’t evaluated the rest. So row 2 the last date is July 2 bc between row 1 and 2 that’s the oldest date and so on until it get to the last row. Any clarification would be appreciated.

Great, no unnecessary jazz and an accent which neither grates nor is difficult to understand. Also that conversion from pesky default date hierarchy -> flat date at 1:52, I honestly didn't know that and I've produced dozens of reports.

This works fine between dates, but I don't see how it would work if you just wanted a cumulative average.

Just curious why you are using the CALCULATE function given that you are not using any FILTER! at time stamp 05:40