What is wrong with this Rolling average (3months).

Hey Speed,

I appreciate your response and I agree.

Therefore I am attaching the sample pbix file of what I want to accomplish.

1) I have data that I pull from a third-party source (API) and load into my Power BI report. In this case, I just used an Excel workbook with the same amount of data.

2) When I put the original prices in the matrix table (not the measure I currently have on there) it shows me gaps in between months because there is no price recorded in that month. Therefore I would take the previous month's price and duplicate it if the month's price is not available.

3) I want to be able to calculate the 3-month rolling average including the prices that I have copied from the previous month that had a value.

4) I believe I have managed to do all that but receive an error  'visual has exceeded the available resources' . I don't want it to do that because it is important to show that visual. Now one issue that I read about is that my measures are using up too much memory. 


Would you be able to help me with this? Here is the link to the file:

https://go.wetransfer.com/t-kDe1NYkiDy

Thank you.