Power BI DAX to multiply values in columns from different tables based on month

[sysk]

Month	Dev Factor
Current Month -12	1.001
Current Month -11	1.001
Current Month -10	1.002
Current Month -9	1.003
Current Month -8	1.004
Current Month -7	1.005
Current Month -6	1.007
Current Month -5	1.009
Current Month -4	1.014
Current Month -3	1.021
Current Month -2	1.033
Current Month -1	1.065
Current Month	0

Accident Month	Claim Count
Dec-22	316
Jan-23	354
Feb-23	477
Mar-23	442
Apr-23	339
May-23	420
Jun-23	344
Jul-23	320
Aug-23	316
Sep-23	301
Oct-23	377
Nov-23	419
Dec-23	0

based on the above tables, i need to calculate ultimate numb of claims = claim count * dev factor, if current month = Dec 2023 then 0 * 0 which should return 0, similarly for Nov 2023 419 * 1.065 and goes on.

[Ahmedx · Accepted solution]

pls try this

[sysk]

Thank you, Much appriciated