Compare Current and Previous Financial

[DonRSA]

Hi 

I have  a dax that compare current  Financial Year and Previous financial year.

E.g if i want to compare one month to another, i have a problem when my current month is not a full month, maybe until the 5th of may,now i want to compare it with another previous month (same month which is may on the previous FY) but it has to calculate sales until the 10th.  I have two calenders(First Calender and Comparison Date)

This is what i have sofar:

My fincial year starts July and end June

My Measures:

1st. I'ts financial year is FY23,i do have a column for that

Sales = SUM('TableA'[Sales Value])

2nd:I'ts financial year is FY22,i do have a column for that

Compare =

Var SelectedMOnth = SELECTEDVALUE('Comparison Date'[Fiscal Month Name])

Var MonthSales =CALCULATE([Sales],All('First Calender'),

USERELATIONSHIP('Comparison Date'[Date] ,'First Calender'[Date]),'Comparison Date'[Fiscal Month Name]=SelectedMOnth)

return MonthSales

The Sale measure it's from July until May 05

The Compare Measure is adding everything until June,and i want it to compare until 05.

Please see Picture Below, How do i Solve this?

[DonRSA]

Hi,anyone who can help please