Help building report showing employees working more than 14 days straight 12 hour shifts

[longshotkickdeb]

Hello,

Employees fill out daily report, day/night shift 12 hour maximum. I have Power BI looking at all these reports daily for 2018. Would like to see if employees are working more than 14 consecutive days with 12 hour shifts. Can this be done I am a complete novice. 

[v-chuncz-msft · Accepted solution]

@longshotkickdeb,

You may take a look at the following posts.

• https://community.powerbi.com/t5/Desktop/Find-Consecutive-Rows/td-p/539259
• https://community.powerbi.com/t5/Desktop/Find-min-date-where-continuous-8-rows-of-data-in-the-calcul...

[longshotkickdeb]

Sorry, please. Forgot my manners 😞