Issue with rolling average based off item type

Hello, I'm looking to create a rolling 90 day/3 month average of LeadTime over the course of a year. This is what my data looks like

The issue with this is I have three different WorkItemType values: "Task", "Feature" and "PBI" so even though all the data is in a single table, I need three different rolling averages, one per type.

The DAX I have so far is for a single type, Feature. I assume I will need 3 measurements in total, one for each.

Rolling Average = VAR LastTransactionDate = MAX('Query1'[CompletedDateSK])
VAR AverageDay = 90
VAR PeriodInVisual = 
FILTER(
    ALL(
        'Query1'[CompletedDateSK]
    ),
    AND(
        'Query1'[CompletedDateSK] > LastTransactionDate - AverageDay,
        'Query1'[CompletedDateSK] <= LastTransactionDate
    )
)
VAR WorkItemType =
FILTER(
    ALL(
        'Query1'[WorkItemType]
    ),
    AND(
        'Query1'[WorkItemType] = "Feature",
        'Query1'[WorkItemType] = "Feature"
    )
)
VAR OutPut =
CALCULATE(
    AVERAGEX(
        'Query1',
        [LeadTimeDays]
    ),
    PeriodInVisual, WorkItemType
)
RETURN
OutPut

Which feels like it can be improved. I'm also not sure it is calculating the right values either, since the rolling average is being calculcated as the same as the month average

How can I calculate rolling average correctly given my data?

Thanks!