Forum Discussion

bourne2000's avatar
bourne2000
Helper V
3 years ago
Solved

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

  • CNENFRNL's avatar
    CNENFRNL
    Community Champion

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