cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Frequent Visitor

## Cummulative count for laboral days worked

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!

Super User

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - August 2024

Check out the August 2024 Power BI update to learn about new features.

#### Fabric Community Update - August 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors