Cummulative count for laboral days worked

[PeterCyos]

Hi everybody!

I am trying to make an accumulated sum of the days that an employee has worked in a row, but I need it to restart and not count the weekends, that's why I have a table similar to this one.

I have created a table with the columns I have, (Days, Name, Labor day, Worked?) and the result I would like to have (Days in a row).

Days	Name	Labor day	Worked?	Days in a row
01/01/2023	Frank	false	false	0
02/01/2023	Frank	true	true	1
03/01/2023	Frank	true	true	2
04/01/2023	Frank	true	true	3
05/01/2023	Frank	true	true	4
06/01/2023	Frank	true	true	5
07/01/2023	Frank	false	false	5
08/01/2023	Frank	false	false	5
09/01/2023	Frank	true	true	6
10/01/2023	Frank	true	true	7
11/01/2023	Frank	true	true	8
01/01/2023	Gary	false	false	0
02/01/2023	Gary	true	true	1
03/01/2023	Gary	true	true	2
04/01/2023	Gary	true	false	0
05/01/2023	Gary	true	true	1
06/01/2023	Gary	true	true	2
07/01/2023	Gary	false	false	2
08/01/2023	Gary	false	false	2
09/01/2023	Gary	true	true	3
10/01/2023	Gary	true	true	4
11/01/2023	Gary	true	true	5

I leave here the example of what I have done so far in case it can help.

Var Counter = 

 SUMX(FILTER( BBDD, BBDD[employeeId] = EARLIER(BBDD[employeeId]) && BBDD[dates] <= EARLIER(BBDD[dates]) && (EARLIER(BBDD[worked])=True() ), BBDD[Worked] )
Return if( BBDD[Worked]=true() && BBDD[Labor day] =true(), counter,
 if( BBDD[Worked]=false() && BBDD[Labor day]=true, counter-counter)

Thanks in anycase!

[johnt75]

I think you can use or adapt the technique in https://www.youtube.com/watch?v=8M8mgfZsTS0