Finding Consecutive number and counting

Hi Anonymous ,

Do you want to count the number of consecutive absences or the length of each absence, grouped by name? Would the following formula be helpful to you.

a =
VAR next_ =
    TOPN (
        1,
        FILTER (
            'Table',
            'Table'[Sr No] < EARLIER ( 'Table'[Sr No] )
                && 'Table'[Name] = EARLIER ( 'Table'[Name] )
        ),
        [Sr No], DESC
    )
VAR next_status =
    MINX ( next_, [Status] )
RETURN
    IF ( 'Table'[Status] = "Absent" && 'Table'[Status] = next_status, "yes", "no" )

If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.

Best Regards,
Henry

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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.