cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper I
Helper I

Covid Colombia Moving Average

Hello

How can I get a 7-day moving average with a table that has many records per day in the date column, that is, many rows for each day of the date? I've watched all the YouTube videos but it doesn't work for me in any way. I guess it's that detail. I haven't managed to find an example like the one I'm trying to figure out. Help!

Thank you 😉

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support
Community Support

Re: Covid Colombia Moving Average

Hi @ManuelEspitia , 

You could try to use built-in expression(rolling avg) or use your custom expression. You could refer to my sample for details.

Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

View solution in original post

2 REPLIES 2
Highlighted
Super User V
Super User V

Re: Covid Colombia Moving Average

Hi,

Share some data and show the expected result.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
Highlighted
Community Support
Community Support

Re: Covid Colombia Moving Average

Hi @ManuelEspitia , 

You could try to use built-in expression(rolling avg) or use your custom expression. You could refer to my sample for details.

Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

View solution in original post

Helpful resources

Announcements

August Community Highlights

Check out a full recap of the month!

Experience what’s next for Power BI

Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.

Top Solution Authors