Forum Discussion
FTE (Fulltime Equivalent) Calculation with conditions
Hi Gurus I apologise in advance if I have made any beginner errors in my question below as I have never posted a question. I have built a headcount (FTE) report based on daily hours table that cont...
jgeddes
Super User
Super UserYou can try something like...
Employee FTE Calculation =
var _allEmployeeHours =
CALCULATE(
[Total Hrs], //calculate total hours
ALLSELECTED(Dates1[Date Key]), //use all of the dates selected by the slicer
ALLEXCEPT(Hours_Report, Hours_Report[Employee Number]) // remove the visual context filters except the employee number
)
var _fteCalc =
SWITCH(
TRUE(),
CALCULATE([Total Hrs], Hours_Report[Labour Group] = "Perm") = _allEmployeeHours, 1, // if the sum of total hours in the 'Perm' group equals all the hours for that employee FTE = 1
DIVIDE([Total Hrs], [Work Days] * 7.6, 0)
)
Return
_fteCalc