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...
You can't upload a PBIX file here, but you can upload to a dropbox, onedrive or googledrive and share a readonly link
Thanks Phill,
Here is the link, hope it helps to get a better understanding
https://drive.google.com/file/d/0BxialLPjHTpbVmlvMk5DUTBfbW8/view?usp=sharing
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