Forum Discussion

julsr's avatar
julsr
Icon for Continued Contributor rankContinued Contributor
1 year ago
Solved

DatesMTD error when using all the data in my database

Hello everyone! I'm using the datesMTD calculation to get Month To Date values. First, I used it with one year of data, and it worked. Now, I've tried using it for 13 years of information, and I'm ge...
Need Help
Show and Tell
Tips and Tricks
  • bhanu_gautam's avatar
    bhanu_gautam
    1 year ago

    julsr  Try using below DAX

     

    DAX
    TotalMTDValue =
    CALCULATE(
    SUM(database[amount]),
    DATESMTD(DatesTable[Date])
    )

bhanu_gautam's avatar
bhanu_gautam
Icon for Super User rankSuper User
1 year ago

julsr  Try using below DAX

 

DAX
TotalMTDValue =
CALCULATE(
SUM(database[amount]),
DATESMTD(DatesTable[Date])
)