Dear, good afternoon
I need to apply a look where I put the cumulative total to today (10/15/2019) and target the cumulative total from the previous year to today (10/15/2018).
last scan =
CALCULATE (
MAX ('EXAMS - IMAGE' [GREATEST_DATE_TIME]); ALL ('EXAMES - IMAGE')))
var datalimit = EDATE (last scan; -12)
return
CALCULATE (
[_totalExams];
'EXAMS - IMAGE' [HIGH_REAL_DATE_TIME] <= date limit)
