Average based on dynamic start and end time periods

Hi All,

I'm hoping someone can help. I'm trying to create a formula for a planning solution that calculates an average over a dynamic number of time periods but for hundreds of intersections. So essentially I somehow need a data buffer covering multiple time periods that I can then use in my over arching planning formula.

The main thought was to loop through the time periods, which is fine, but I can't use an api.data.getdatacell because of the volume of intersections I want to calculate the average for. Is it possible to build up a data buffer in a loop?

If only i could create a V#TrailingXmonthavg  formula where I can replace the X with a dynamic value.

Any thoughts would be greatly appreciated.

Many thanks in advance.