Forum Discussion

AndersonLegnar's avatar
AndersonLegnar
Frequent Visitor
9 years ago

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...
Need Help
Phil_Seamark's avatar
Phil_Seamark
Microsoft Employee
9 years ago

HI AndersonLegnar

 

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
                    )
                    )
  • AndersonLegnar's avatar
    AndersonLegnar
    Frequent Visitor
    9 years ago

    Hi Phil,

     

    This measure gives me the cumulative figure, but that doesn't do the trick

     

    • Phil_Seamark's avatar
      Phil_Seamark
      Microsoft Employee
      9 years ago

      I thought that might be what you were after.  The total number of students in your school on any given year

      • AndersonLegnar's avatar
        AndersonLegnar
        Frequent Visitor
        9 years ago

        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?