Calculating MTD

[bourne2000]

Hi

I am having a below table called "Data"

I wanted to calculate YTD and MTD for sales. My data has both 2022 and 2023 data. I created date table and connect with the above table

I used below measure to calculate MTD but no success

MTD = TOTALMTD(SUM(Data[Sales]), 'Date'[Date])

The above MTD calculation is incorrect, it just printing the same value and not adding. 

Attached PBIX here https://we.tl/t-xzzcQZ86ku

Can anyone advise what is wrong with my DAX?

[CNENFRNL · Accepted solution]

I'm wondering why so many beginners opt for such a meaningless, huge calendar date.