Calculate if the employee has worked for consecutive 7 days

[Anonymous]

So I have a file with multiple employeeId as Column A and their workedDate as Date in column B.

I need to calculate how many consecutive days the employee has worked. *specifically if he/she has worked for 7 consecutive days.

Thank you

[Anonymous · Accepted solution]

This link helped me solve the problem

https://community.powerbi.com/t5/Desktop/Counting-number-of-occurrences-in-a-month/td-p/347498

[v-juanli-msft]

Hi @Anonymous 

Please refer to some useful articles:

https://powerpivotpro.com/2018/01/consecutive-days-back/

https://powerpivotpro.com/2016/12/how-many-working-days-has-an-employee-been-off-work/

If it doesn't help, please share more detials.

Best Regards
Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[JosefPrakljacic]

Hey @Anonymous ,

please check if this thread is ofering the result you want.

Otherwise may I ask you for some sample data and a sample result

BR,

Josef