5-Day Moving Average

I want to thank everyone for their advice...I had tried adapting similar solutions, but could not get anything to work for what I needed. I recognize the problem of not being able to post the data...the data set is large.  I could pare it down to just a couple of counties and 10-20 days, I guess, and post that. If you look at the inelegant solution I ended up with, you might be able to tell from that what I would need to do to write a smarter DAX query. 

Best regards,

Rip