DATESMTD stops working

[Craig_NPDL]

Hi everyone

I have created a Dashboard which I have been using for a number of months now. One of the visuals is a cumulative line graph that reports month to date performance - it updates daily.

The date table has been set up with the following DAX statement - MyCalendar2 = CALENDAR("1/1/2020",today()).

The data table is linked to the date table by a Date field (Data type = Date)

The month to date graph has been working successfully with no issues.

I have updated how we collect the data using an improved MS Form so I am trialling using the new Data table to replace the original table. To ensure everything works before replacing the original table, I have imported the new data table, replicated the settings and links to match the orignal table and created a new measure to test results. The 2 measures are below:

Original:   ObservationsQR MTD = CALCULATE((COUNT(SamoaQR_Obs[ID])),DATESMTD(MyCalendar2[Date]))

New:   ObservationsQR MTD Test = CALCULATE((COUNT(MstrQRObs[ID])),DATESMTD(MyCalendar2[Date]))

The original continues to work fine but the new calculation returns "Blank". I know it took me a while to get the measure and graph working but after matching the data types and links, I cannot figure out what to do next. Can anybody help and suggest something else I should look at?

[Anonymous]

Hi @Craig_NPDL ,

Based on the details you’ve provided, it appears that the DATESMTD function is not returning any data for the new table ‘MstrQRObs’. To gain a more comprehensive understanding of the issue and to facilitate further troubleshooting, could you kindly provide the following information?

• Please check if there is any data in the table 'MstrQRObs' during the selected period?
• Please make sure that the relationship between MyCalendar2 and MstrQRObs is set up correctly. The Date field in MstrQRObs should be linked to the Date field in MyCalendar2.

• Please check if the table 'MstrQRObs' has the same settings with the table 'SamoaQR_Obs'? Data type, data, relationship etc.

Best Regards