Showing results for 
Search instead for 
Did you mean: 
Helper II
Helper II

Count STAFFID who have not submitted timesheets over consecutive weeks

Hi All,

I have been searching and finding it hard to adapt similar posts to my situation. I apologise if I am asking the wrong questions here and your help would be great.



  1. I would like to create a DAX measure to count the consecutive weeks they have not submitted a timesheet.
  2. I would also like to display staff names who have not submitted a timesheet in the past 5 weeks



Week StartStaffIDStaffNameRecorded HoursProject Assignment IDProject Start DateProject End DateActive Assignment?


Dataset Limitations:

  • The extracted data I receive only provides details of the actual time that a staff records against their assignments.
  • Unfortunately, there is no 'Planned Hours' per week column, if there was, then there would be a row for each week between the project start and end date, which would make this alot easier to do.
  • We can only assume based off the project start and end date that they are required to timesheet each week up until the end date of the project.
    • 'Active Assignment' column is derived value. i.e. IF([Project End Date] > [Week Start], 'Yes', 'No')

Expected result:

  • Staff NameConsecutive Weeks with No timesheet



Many thanks


Helpful resources

Join Arun Ulag at MPPC23

Join Arun Ulag at MPPC23

Get a sneak peek into this year's Power Platform Conference Keynote.

PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

Top Solution Authors
Top Kudoed Authors