Need to calculate values between 2 dates dynamically

[amks]

Hi,

I have had production values since 2017. as of the date I want to calculate matured product production total based on the product warranty.

example:

Mfg. Month & Year	Mfg. Qty (Nos)	Warranty Return Qty.(Nos)	Warranty Return %
Apr-19	2,340	25	1.07%
May-19	2,340	25	1.07%
Jun-19	2,340	25	1.07%
Jul-19	2,340	25	1.07%
Aug-19	2,340	25	1.07%
Sep-19	2,340	25	1.07%
Oct-19	2,340	25	1.07%
Nov-19	2,340	25	1.07%
Dec-19	2,340	25	1.07%
Jan-20	2,340	25	1.07%
Feb-20	2,340	25	1.07%
Mar-20	2,340	25	1.07%
Apr-20	2,340	25	1.07%
May-20	2,340	25	1.07%
Jun-20	2,340	25	1.07%
Jul-20	5,640	144	2.55%
Aug-20	5,353	129	2.41%
Sep-20	840	24	2.86%
Oct-20	4,980	34	0.68%
Nov-20	3,600	35	0.97%
Dec-20	3,414	144	4.22%
Jan-21	3,302	129	3.91%
Feb-21	3,190	24	0.75%
Mar-21	3,078	34	1.10%
Apr-21	2,966	35	1.18%
May-21	2,854	144	5.05%
Jun-21	2,742	129	4.70%
Jul-21	2,630	24	0.91%
Aug-21	2,518	34	1.35%
Sep-21	2,406	35	1.45%
Oct-21	2,295	144	6.28%
Nov-21	2,183	129	5.91%
Dec-21	2,071	24	1.16%
Jan-22	1,959	34	1.74%
Feb-22	1,847	35	1.90%
Mar-22	1,735	144	8.30%
Apr-22	1,623	129	7.95%
May-22	1,511	24	1.59%
Jun-22	1,399	34	2.43%
Jul-22	1,287	35	2.72%
Aug-22	1,176	144	12.25%
Sep-22	1,064	129	12.13%
Oct-22	952	24	2.52%
Nov-22	840	34	4.05%
Dec-22	728	35	4.81%
	1,07,281	2,571	2.40%
			Cumulative warranty

need below calculation Dax in power BI

Matured warranty calculation:	Today-Warranty period offred months
Today	20-Jan-23
Warranty offered Months - this is dynamic & varies from product to product	21
Matured warranty	20-Apr-21
Need to calculate total production & Claims from Apr-21 to Apr-2019 backward) - this is dynamic & varies from product to product
Production Apr-19 to Apr-21		71462
Warranty Return Qty Apr-19 to Apr-21		1,107
	Mature wararnty	1.55%

support is required, please

thanks in advance.

[amks]

Dear  lbendlin,

Thanks for your input.

but I need Dax to calculate the production & return quantity based on the dates. not total warranty %

like: if my product warranty matured till Apr'21 I need to calculate the total from apr'21 to back wards & extract the return percentage from it .( I will do Edate formula in excel & sum commutative from that date to backdated )

the mature warranty date varies from product to product which I have in another table.

I tried dates between & dateadd but couldn't get exact results.

[lbendlin]

Your date slicer already does all the work for you.  You can adjust the measure I posted to show the individual sums, or use implicit measures.

[lbendlin]

something like this?

see attached