Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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])
) )
Solved! Go to 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.
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.