Forum Discussion
Sean500
Helper I
3 years agoHow to calculate average entry time?
Hi
I am trying to fine the average time in Power BI. I have a table called "Sheet1" which has Date (dd/mm/yyyy), Time (Hr:MM:SS am/pm), EmployeeID, EntryType (Binary 0 AND 1). This is Employee attedance record. Ths table has multiple employees and each employee enters and exit office multiple times on a single day.
I wanted to calculate Average Entry time for each employee. I did in Excel and took the below example for three days for one employee
I tried to do this in below dax measures, but no success. It gives minimum time not average
Average Entry Time =
VAR MinEntryTime =
CALCULATE(
MIN('Sheet1'[Time]),
'Sheet1'[EntryType] = 1
)
RETURN
AVERAGEX(
VALUES('Sheet1'[EmployeeID]),
MinEntryTime
)
Can anyone advise how to do this? I have multiple dates and employee ID's
No RepliesBe the first to reply