Count values of the same month last year

[Anonymous]

I read through other suggestions and used SAMEPERIODLASTYEAR, and managed to make it work, except that when I filter the data, the fields all stop working. Doing more research on it, I found that for the SAMEPERIODLASTYEAR to work, it has to have all consective dates, so I created a CALENDAR Table, but now the previous measure isn't working. 

What am I missing?

CASES LAST YEAR =
CALCULATE(
DISTINCTCOUNT('Division CAS Report'[CAS Case ID]),
DATESMTD(SAMEPERIODLASTYEAR('Calendar'[DATES])
) )

[Ashish_Mathur · Accepted solution]

Hi,

From the Calendar Table, drag Year and Month to the slicer/filter section.  Select any year and month.  Write this measure

CASES LAST YEAR=CALCULATE(DISTINCTCOUNT('Division CAS Report'[CAS Case ID]),SAMEPERIODLASTYEAR('Calendar'[DATES]))

Hope this helps.