Forum Discussion
Solved
running diff after sum
hi i have to tables, upon them i am creating list which aggregate the measure in a list. i want to create running diff on rows. attach picture.
hi, yogevz
After my test, you could use this formula to create a measure as below:
Measure = CALCULATE([Count_student measure])- CALCULATE([Count_student measure],FILTER(ALL(Sheet1),Sheet1[Foreign]=MAX(Sheet1[Foreign])-1))
Count_student measure is a measure which count students.
Result:
Best Regards,
Lin
i can't....
the count_student is a measure which count students...
so the column phrase can't see this measure.
this is the problem....
hi, yogevz
After my test, you could use this formula to create a measure as below:
Measure = CALCULATE([Count_student measure])- CALCULATE([Count_student measure],FILTER(ALL(Sheet1),Sheet1[Foreign]=MAX(Sheet1[Foreign])-1))
Count_student measure is a measure which count students.
Result:
Best Regards,
Lin