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

Is it possible for me to upload the pbix file?

I've cleaned it up, but can't find a way to do so.

 

 

Phil_Seamark's avatar
Phil_Seamark
Microsoft Employee
9 years ago

Hi AndersonLegnar

 

You can't upload a PBIX file here, but you can upload to a dropbox, onedrive or googledrive and share a readonly link

    • 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