Forum Discussion
Calculate Dynamic average time
In my tabe i have each employees timgings for each day. i would like to calculate the average timings for each employee as time range changes. sample data:- Emp ID Time 136225 9:...
Got by myself..
Below query worked.
AvgTime = CALCULATE(FORMAT(AVERAGE('Table'[Time]),"HH:MM:SS"),FILTER(ALLEXCEPT('Table','Table'[Emp ID]), 'Table'[begin_date] <= MAX('Table'[begin_date])))
Got by myself..
Below query worked.
AvgTime = CALCULATE(FORMAT(AVERAGE('Table'[Time]),"HH:MM:SS"),FILTER(ALLEXCEPT('Table','Table'[Emp ID]),
'Table'[begin_date] <= MAX('Table'[begin_date])))