Month-To-Date Fails

Hi

I have a report in which I was calculating Month-To-Date and Year-To-Date values using TOTALMTD and TOTALYTD functions respectively, successfully. But after crossing over into this year 2021, the Month-To-Date is no longer working (gives (Blank)) but the Year-To-Date still working correctly.

I have recreated the issue using a simple Data table with three columns:-

RecordID with 64 unique rows;

RecordDate with dates from 1st January to 8th January 2021 (today is 9th January where I am);

RecordAmount with currency values that total 8,112,554.00

I also have a Date table with a Start Date of 01/01/2021 and End Date of 31/12/2021.

I have a one-to-many relationship between the Date in Date table and RecordDate in Data table.

DAX:

The count and sum are calculated using the formulas:

TotalCount = COUNT ( Data[RecordID] )

TotalValue = SUM ( Data[RecordAmount] )

 The Year-To-Date formulas are as follows, giving the result as 64 for count and 8,112,554.00 for value:

YTDCount = TOTALYTD( [TotalCount], 'Date'[Date] )

YTDValue = TOTALYTD( [TotalValue], 'Date'[Date] )

However the following Month-To-Date formulas are giving (Blank) result:

MTDCount = TOTALMTD( [TotalCount], 'Date'[Date] )

MTDValue = TOTALMTD( [TotalValue], 'Date'[Date] )

MTDValue2 = 
    CALCULATE( 
        [TotalValue], DATESMTD('Date'[Date])
    )

Ideally, since we are in the first month of the year, the Month-To-Date formulas should give the same result as the Year-To-Date.

But why are these Month-To-Date formulas not working? Where am I going wrong? Why were they working till 31st December 2020?

Here's the Data table data: