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...
I wanted to know how the field is calculated because it looks like the 2nd row has a value of 23.
I think I see now that the second row is not 'Autumn 23' but 'Autumn 2' space '3'. Is that right?
--
In DAX there is no order in a table unless we apply some. Will there always be 3 values for each ID? Are they always ordered as in the example?