Need Rolling Average based on other columns in Table

[glasshalfasleep]

Okay I spent several hours trying to use the posts that are already out there with no luck. 

I have a table of Resources, Date, Billing Hours, Working Hours, Percent Billable. I need to get a rolling average per person based on the current's rows date. So I already did a Calculation to get Percent Billable each week which is the Billable Type Hours / Working Hours. 

However, what I need is the following: 

Here is how I would do it in Excel:

Anyone have any idea how to get the DAX Expression to give me that?

I also need Weeks Aging when Rolling Average is under 70% but I think that if i get the rolling average i can figure the other, but feel free to give me both!!

Thanks so much in advance!!

[glasshalfasleep · Accepted solution]

I was able to get this figured out myself eventually. 

[YukiK]

This might help! https://community.powerbi.com/t5/Desktop/Moving-Average/m-p/43041

[glasshalfasleep]

Nope its still not using both Resource Name and the Date Range. When i do any of those calculations i end up with the same number and not an average.