Trending Late Values Over Time

I created a way but it is a lot of manual input.

1. First I created a simple yes (value 1) or no (value 0) column if the part was ever late.

2. I then created calculated columns for every month in a year.  This tracks the days late on each row for the respective month.  So I have a 202501 Days Late, 202502 Days Late, etc for each item.  

3. I then had to create a new table to get the date into each row.  This creates multiple rows for each part, but has the late value based on the month.

• CombinedSummaryTable =filter( union(summarize('BaseTable','BaseTable'[Part],'BaseTable'[202501DaysLate],'BaseTable'[Qty],"Date", "2025-01-31",Avg Months", round(average('BaseTable'[202501DaysLate]/30.44,0)),.......{repeat for other months}, not(isblank('BaseTable'[202501DaysLate])
  
  Now I can use a date slicer and another slicer for the Part to see late values over time.