Forum Discussion
Finding Consecutive number and counting
Hi, I have attached data set and expected output as well, but not sure how to get the perfect DAX to find the consecutive number and counting. Pls refer the below and let me know how is this ...
I want to see consecutive count of number of absent like total number of absent by student absent continiously 2 times, 3 times and 3 plus times. so that I can focus on the student who are absent frequently continiously.
Ex: ABC is continiously absent 4 times from March 11 to May 12. Absent 2 times from May 14th May 15
3 plus 2 times
ABC 1 1
DEF 0 2
Any solution pls.