Forum Discussion
How to flag and group consecutive dates by employee using either Power Query or Power BI
Hello, I've been struggling to figure out how to how to flag and group consecutive dates by employee, then summing days using either Power Query or Power BI. I tried using Power Bi but it lead me to a "calculated" column that I cannot chart, filter or do further analysis on.
Help Please 🙂
Data & Output
Output
Level 4 Level 3 Level 2 Full Name Consecutive Groups Sum NB Days by Consecutive Groups
Kelly Sarah Ashley Joan 3 8.5
Trisha 5 11.07
DATA
Level 4 Level 3 Level 2 Full Name Code Date NB Day Consecutive Groups Sum NB Days by Consecutive Groups
Kelly Sarah Ashley Joan 12/03/22 1
12/29/22 1 1 2
12/30/22 1
4/11/23 0.5
5/02/23 1
5/11/23 0.5 2 2.5
5/12/23 1
5/13/23 1
5/15/23 1 3 4
5/16/23 1
5/17/23 1
5/18/23 1
Trisha 7/19/22 0.78 1 2.92
7/20/22 1.07
7/21/22 1.07
8/12/22 1.07
9/01/22 1.07 2 2.14
9/02/22 1.07
10/15/22 0.93 3 2
10/16/22 1.07
11/07/22 1.07 4 2.14
11/08/22 1.07
11/17/22 0.8 5 1.87
11/18/22 1.07
No RepliesBe the first to reply