Forum Discussion
Calculating Difference from Previous Row
Hi, we have a table of data and results for each half term for a unique ID. Example table below - what I want to be able to find is the half termly changes in grade value between half terms (excl...
Yes that is correct so there are 6 Half Terms per year - Autumn 1/Autumn 2, Spring 1/Spring 2 and Summer 1/Summer 2
For this year so far we only have up to Spring 1 grades (which is what I've used as the example) but as the year progresses that could get to a maximum of 6 records per Unique ID.
In PBI Query I have sorted the Unique IDs by the in year half terms so it should be in order yes.