Power Pivot Calculated formula for 24 Months Moving total

[sanket_sk]

Hello,

I'm trying to figure out how to build a power pivot calculated formula with a (24Month) Moving total.

With this, I will update sales & complaints data in power pivot data every moving month and expecting excel to calculate moving total similar to below given excel formula

Below is example

Type	Jan-17	Feb-17	Mar-17	Apr-17	May-17	Jun-17	Jul-17	Aug-17	Sep-17	Oct-17	Nov-17	Dec-17	Jan-18	Feb-18	Mar-18	Apr-18	May-18	Jun-18	Jul-18	Aug-18	Sep-18	Oct-18	Nov-18	Dec-18	Jan-19	Feb-19	Mar-19	Apr-19	May-19	Jun-19	Jul-19	Aug-19	Sep-19	Oct-19	Nov-19	Dec-19
Sale	1851	838	1543	1374	835	387	902	3320	3402	9172	16304	3302	1032	905	855	999	1240	1862	432	2004	5416	13870	24396	3511	1720	821	941	1274	1106	1140	699	3710	8362	13100	26961	2332
Complaints													2196	761	660	522	548	602	425	493	677	949	5432	3869	4339	1988	1354	1056	979	608	643	734	958	2122	10576	4912
Result
	Jan-19	Feb-19	Mar-19	Apr-19	May-19	Jun-19	Jul-19	Aug-19	Sep-19	Oct-19	Nov-19	Dec-19
24 Month Moving total Sale	99752	99621	99604	99002	98902	99173	99926	99723	100113	105073	109001	119658
24 Month Moving total Complaints	17134	21473	23461	24815	25871	26850	27458	28101	28835	29793	31915	42491
Complaint Ratio	17%	22%	24%	25%	26%	27%	27%	28%	29%	28%	29%	36%

Thanks & Regards
Sanket