Annualised Financial Year

Hi,

So I have three tables:

1) A Financial Year Table FY[] that has a column a month year "MMM YYYY" and one for the corresponding Financial Year

Jan 2024 | FY24

2) I have a DateDimension Table that contains every date until 2044, it also relates the month year column from Financial Year table, so that it links the FY to a specific date

3) I have a raw data table that contains all quality defects raised by a customer, this table contains the date the defect was raised in the system and the type of defect.

My goal is to have a pareto of the top defect types by financial year (including annualised for current Financial year). The struggle is that when we are in FY24, i would like to have it annualised, so that I can see where we are headed improving or deteriorating.

Do you have any ideas for a measure and calculation that could link these tables?

Thanks

Michael