Forum Discussion
Solved
Continuous Attendance
Hi Everyone, 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 d...
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
Continuously_Present = VAR mycontinuousdays = 7 RETURN IF ( [Date] + mycontinuousdays - 1 = CALCULATE ( MIN ( [Date] ), FILTER ( Table1, [EMP No] = EARLIER ( [EMP No] ) && [Index] = EARLIER ( [Index] ) + mycontinuousdays - 1 ) ), "Present" )
Hi, I'm trying to solve similar problem to find the employee count who consectively worked more than 6 days. I'm using power Pivot to solve the same but I'm getting below error. My data looks similar some what similar