Numbers not matching

Hello,

I tfeels like I have a weird issue and I hope I am missing something simple.

So I have two measures.  The first calculates the revenue for each month as long as the start date is equal to or before the last day of the month and the end date is greater than the last day of the month.

The second is designed to capture forecast so needs to assume that the end date doesn't come.  So it has the end date fixed to the 31st Jan 2025.  My challenge is that when I look at January 2025 in the output this should then have exactly the same value in both.  But it doesn't:

Of course if I change the date in Forecast MRR to 'MaxDate' then the numbers match.  I even verified that MAX was indeed looking at the 31st Jan for it.

MRR Revenue = 
VAR BaseTable = SUMMARIZE( 'GBP', 'Dates2'[Month Year], 'GBP'[Source], 'GBP'[Rate] )
VAR ConvertedValueGBP = SUMX(
	BaseTable,
	VAR MaxDate = CALCULATE( MAX( 'Dates2'[Date] ) )
	VAR Source = 'GBP'[Source]
	VAR Result = CALCULATE(
		SUM( Combined[MRR] ),
		Combined[End Date] > MaxDate,
        Combined[Start Date] <= MaxDate,
        Combined[PON or Not] IN { "PON", "Excluded" },
		Combined[Currency] = Source
	) * 'GBP'[Rate]
	RETURN Result
)
VAR BaseTable2 = SUMMARIZE( 'EUR', 'Dates2'[Month Year], 'EUR'[Source], 'EUR'[Rate] )
VAR ConvertedValueEUR = SUMX(
	BaseTable2,
	VAR MaxDate = CALCULATE( MAX( 'Dates2'[Date] ) )
	VAR Source = 'EUR'[Source]
	VAR Result = CALCULATE(
		SUM( Combined[MRR]),
		Combined[End Date] > MaxDate,
        Combined[Start Date] <= MaxDate,
        Combined[PON or Not] IN { "PON", "Excluded" },
		Combined[Currency] = Source
	) * 'EUR'[Rate]
	RETURN Result
)
VAR UnconvertedValue = SUMX( VALUES( Dates2[Month Year] ),
	VAR MaxDate = CALCULATE( MAX( 'Dates2'[Date] ) )
	VAR Result = CALCULATE(
		SUM( Combined[MRR $] ),
		Combined[End Date] > MaxDate,
        Combined[Start Date] <= MaxDate,
        Combined[PON or Not] IN { "PON", "Excluded" },
		ISBLANK( Combined[Currency] ) 
	)
	RETURN Result
)
VAR Result = ConvertedValueGBP + UnconvertedValue + ConvertedValueEUR
RETURN Result

and:

Forecast MRR = 
VAR BaseTable = SUMMARIZE( 'GBP', 'Dates2'[Month Year], 'GBP'[Source], 'GBP'[Rate] )
VAR ConvertedValueGBP = SUMX(
	BaseTable,
	VAR MaxDate = CALCULATE( MAX( 'Dates2'[Date] ) )
	VAR Source = 'GBP'[Source]
	VAR Result = CALCULATE(
		SUM( Combined[MRR] ),
		Combined[End Date] > date(2025,1,31), 
        Combined[Start Date] <= MaxDate,
        Combined[PON or Not] IN { "PON", "Excluded" },
		Combined[Currency] = Source
	) * 'GBP'[Rate]
	RETURN Result
)
VAR BaseTable2 = SUMMARIZE( 'EUR', 'Dates2'[Month Year], 'EUR'[Source], 'EUR'[Rate] )
VAR ConvertedValueEUR = SUMX(
	BaseTable2,
	VAR MaxDate = CALCULATE( MAX( 'Dates2'[Date] ) )
	VAR Source = 'EUR'[Source]
	VAR Result = CALCULATE(
		SUM( Combined[MRR]),
		Combined[End Date] > date(2025,1,31),
        Combined[Start Date] <= MaxDate,
        Combined[PON or Not] IN { "PON", "Excluded" },
		Combined[Currency] = Source
	) * 'EUR'[Rate]
	RETURN Result
)
VAR UnconvertedValue = SUMX( VALUES( Dates2[Month Year] ),
	VAR MaxDate = CALCULATE( MAX( 'Dates2'[Date] ) )
	VAR Result = CALCULATE(
		SUM( Combined[MRR $] ),
		Combined[End Date] > date(2025,1,31),
        Combined[Start Date] <= MaxDate,
        Combined[PON or Not] IN { "PON", "Excluded" },
		ISBLANK( Combined[Currency] ) 
	)
	RETURN Result
)
VAR Result = ConvertedValueGBP + UnconvertedValue + ConvertedValueEUR
RETURN Result

.  

 Do you have any thoughts or ideas please?

Thanks