Embedded Measure is not giving me the correct value

I have a report that pulls monthly transactions. The transactions are listed by date, office number and amount into a table labeled "Actuals". The Actual table has a one to many relationship with a date table and I use this date table to present the information by weekly average.

My report shows the average weekly totals for the last 3 month.

I currently have this measure that I manually update every month to assigned the latest month :

1.0-Current Month = "Sep-24"

The above measure is embedded in this measure to get total month amounts based off the Date Table Fiscal Year Month column:

Current Period = 
CALCULATE(
    [Amount], 
    FILTER( 
        ALL('Date Table'), 
        'Date Table'[Fiscal Year Month] = [1.0-Current Month])
        )

I'm trying to streamline the process of having to manually update 1.0-Current Month measure every month by creating a measure give me the current month value based off the monthly transactions date column.

I created the following measure to pull the latest date in the transactions and then to look up that latest date against the Date Table which then provides me with the Date Table Fiscal Year Month value by creating the following measure and embedding it to "Current Period" measure.

Latest Date = 
 LASTDATE(Actuals[FISCAL DATE] 
)

Latest Month = 
LOOKUPVALUE('Date Table'[Fiscal Year Month],
'Date Table'[Date],
[Latest Date])

Current Period(with Latest Month Measure) = 
CALCULATE(
    [Temp Actuals], 
    FILTER( 
        ALL('Date Table'), 
        'Date Table'[Fiscal Year Month] = [Latest Month])
        )

Here are my results and as you can see measure "Current Period(with Latest Month Measure)" does not match the original "Current Period" measure.

I created "Measure Test" to see if "1.0-Current Month" value equals "Latest Month" value which are embedded in the Current Period measures and it shows that the values are the same.

Measure Test = [1.0-Current Month] = [Latest Month]

I've googled this issue and have not found anything. I've tried changing the format of the value, trim the value and still it did not work.

Has anyone have run into this issue or can provide some help? I would highly highly appreciate it.