Rolling 12 months calculation for each month

[powermbz]

Hi folks,

I have a complex calculation to calculate rolling 12 months loss ratio for each month. I have to replicate the below formula to get Rolling 12 month loss rate for each month, what is the best way to achieve this in DAX?

Loss % = 1 - { (1 - (Inflow month 1/Outflow month 1)) * (1 - (Inflow month 2/Outflow month 2)) * (1 - (Inflow month 3/Outflow month 3))  ...... (1 - (Inflow month 12/Outflow month 12))  }

Month	Inflow	Outflow	Calculated Value  (1 - (Inflow month /Outflow month )	Desired Output
Dec-23	5000	400	0.92
Jan-24	5200	800	0.846153846
Feb-24	5250	80	0.984761905
Mar-24	5400	120	0.977777778
Apr-24	5450	125	0.97706422
May-24	5500	100	0.981818182
Jun-24	5600	40	0.992857143
Jul-24	5650	50	0.991150442
Aug-24	5700	150	0.973684211
Sep-24	5750	200	0.965217391
Oct-24	5800	250	0.956896552
Nov-24	5850	230	0.960683761	39%

Any help on his would be much appreciated

[Greg_Deckler]

@powermbz Better Rolling Average - Microsoft Fabric Community