I have below table with employee attendance data from which I need to identify whether there is any employee who has reported to work continuously for 7 days or more. Pls help, may data look like this. Thank you inadvance !
Go to Solution.
Try this calculated column.
It will identify the first day when consecutive 7 days start for each employee
You can then use it as VISUAL filter
VAR mycontinuousdays = 7
[Date] + mycontinuousdays
= CALCULATE (
MIN ( [Date] ),
[EMP No] = EARLIER ( [EMP No] )
= EARLIER ( [Index] ) + mycontinuousdays
View solution in original post
Thank a lot @Zubair_Muhammad
Click here to learn more about the September 2022 updates!
Mark your calendars and join us on Thursday, October 6 at 11a PDT for a great session with Ted Pattison!