Forum Discussion
bourne2000
3 years agoHelper V
Calculating MTD
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?
I'm wondering why so many beginners opt for such a meaningless, huge calendar date.
1 Reply
- CNENFRNLCommunity Champion
I'm wondering why so many beginners opt for such a meaningless, huge calendar date.