Forum Discussion
Predictive Calculations
Hello all, Who is up to a challenge, that I couldn’t sort out :( ? Scenario: We are a secondary school and, like any other school, by the end of the year our students: - Roll up a year (Yea...
As a starting point, do you think a measure like this gets close? It's essentially a rolling sum for the previous 6 years, and if close could be tweaked to get right.
Measure = CALCULATE(
COUNTROWS('All Students') ,
FILTER(
ALL('All Students'),
'All Students'[Start Year] <= MAX('All Students'[Start Year])
&& 'All Students'[Start Year] > MAX('All Students'[Start Year]) - 6
)
)
Hi Phil,
This measure gives me the cumulative figure, but that doesn't do the trick
I thought that might be what you were after. The total number of students in your school on any given year
Hi Phil,
I had a further look and the reason the number is not matching is purely because it is not slicing by EnrollmentStatus.
Anyway to get around that?
Oh definitely. I'll have another look after work tonight. :)