I think this is relatively simple, but I haven’t been able to find the right solution for it. Any help would be greatly appreciated.
I have a table with school report data in it. Each student has a report in each subject several times a year. For each report, they get a number grade (called the attainment track). I want to create a measure that calculates the difference between the average of the most recent report period attainment track grade and the previous report cycle. I need to be able to use the measure in various contexts - e.g. the difference for a student across all their subjects, in each individual subject, for a subject as a whole and so. The report periods use a naming convention of 201718.1, 201718.2 etc. See the example below for a single student in a single subject.
I would also like the user to be able to choose which report cycles they want to compare - they select the first and last report cycles to compare. How might I go about doing this? I’m guessing I need two slicers, the selections of which are used in a measure…
Many thanks in advance,