How to calcuate change from previous year

[Anonymous]

I have a table showing the number of enrolments with Year as my Dimension.  I would like to also show the change in enrolments from the previous year i.e.

I was using the following expression for another chart with a different dimension -

=+SUM({$<simd10={'Y'}, AcademicYearShort ={$(=max(AcademicYearShort))}>}[enrol])- SUM({$<simd10={'Y'}, AcademicYearShort ={$(=max(AcademicYearShort)-1)}>}[enrol])

But it is not working when I have year as my dimension.  I think because the function is using max year compared to max year -1.

Is there another function I can use?

Thanks

Greg

[maxgro · Accepted solution]

maybe with the above function

Missing Manual - Above() and Below()

[Anonymous]

Thanks very much.  Always good to learn another function.