12 months Rolling Average

[rk6755]

Hey Everyone,

I have this dataset and I would like to calculate 12 months rolling average of  Volume_LTE_GB (columnD) per USID (columnC). Can you please guide me through this.

Thank you in advance. 

[binu_acs · Accepted solution]

@rk6755 one way of doing this

[rk6755 · Accepted solution]

Hi @binuacs

Thank you for the quick reply.

However, for 12 month rolling average we should take only 12 months data or 13 months data. In my case it should be from 2023 8th Month to 2024 7th Month?

Can you please confirm.