DatesMTD is not working

Hi, I've created a Date_Table using      DATE_Table = CALENDAR(DATE(2023,01,01),DATE(2023,12,31))      and a Sale column with all 1's    As I created a Calculated Column using DATESMTD fu...