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])
    )

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi julsr ,

 

At my knowledge, using time intelligence functions requires the date table to be continuous and non-repeating date range.

Does your date table contain duplicate dates? If so, please try using the calendar() function to create a date table.

 

Best Regards,

Wearsky