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?
