Forum Discussion
PowerBI Employee Time Tracking Data
Hello, I have been working on a PowerBI report that is intended to tack our student employees time versus their schedules. I have run into several issues, and could use some help. Here is the backgro...
Anonymous ,
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
One of the column you need will be
Attendance Status =
_Schstrat =maxx(filter(Employee, datevalelue(Employee[Actual Start Time]) = datevalelue(Schedule[Scheduled Start Time])),[Scheduled Start Time])
IF(
Employee[Actual Start Time] >= _Schstrat ,
IF(
Employee[Actual Start Time] <= _Schstrat + TIME(0, 15, 0),
"On Time",
"Tardy"
),
"Absent"
)
Scan status =
if(
isblank([actual end time] ) && [actual start time] <> blank(),
"mismatched scan out",
if(
[actual end time] <> blank() && isblank([actual start time]),
"mismatched scan in",
""
)
)