Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
Requirements:
Dataset:
Week Start | StaffID | StaffName | Recorded Hours | Project Assignment ID | Project Start Date | Project End Date | Active Assignment? |
07/05/23 | 001 | Alice | 37.5 | A1 | 01/05/23 | 30/06/23 | Yes |
14/05/23 | 001 | Alice | 37.5 | A1 | 01/05/23 | 30/06/23 | Yes |
21/05/23 | |||||||
28/08/23 |
Dataset Limitations:
Expected result:
Staff Name | Consecutive Weeks with No timesheet |
Alice | 2 |
Many thanks
User | Count |
---|---|
42 | |
26 | |
21 | |
16 | |
15 |
User | Count |
---|---|
54 | |
35 | |
18 | |
17 | |
15 |