Table with 4.5 million records having data since 2022 till 2027, need to calculate rolling12, future12 calculations for some of the KPIs for each month. Used data scaffolding with calendar table, but this impacts performance, any other suggestion please

This latest response is unfortunately a ChatGPT post. Based on the number of responses overnight and through today, the effort might even be automated. We have a BAN on any A.I. posts due to the high error rate.  So, we're considering these posts as spam. Apologies for any inconvenience this may have caused.