Forum Discussion

jsangerman's avatar
jsangerman
Icon for Helper II rankHelper II
5 years ago
Solved

Calculating full-time equivalent (FTE)

I'm having trouble coming up with the formula to calculate a full-time equivalent based on employee timesheet data. A full-time equivalent refers to the time spent on a given project as a fraction (d...
Need Help
  • lbendlin's avatar
    lbendlin
    5 years ago

    Your simple exceptions aren't that simple. In the first case you can use the MIN() function, for example 

     

    hourstocount = MIN(8,hoursworked)

     

    to cap at 8 (ignoring the fact that you are penalizing the worker for doing more work).  For the second scenario use ALL() or ALLSELECTED() or ALLEXCEPT() to modify the filter context inside the computation.

  • Icey's avatar
    Icey
    5 years ago

    Hi jsangerman ,

     

    Try to show values as "Percent of column total". Or create a measure like below.

     

    Measure =
DIVIDE (
    SUM ( 'Table'[Efforts (hours)] ),
    CALCULATE (
        SUM ( 'Table'[Efforts (hours)] ),
        ALLEXCEPT ( 'Table', 'Table'[Date], 'Table'[User] )
    )
)

     

     

    Best regards

    Icey

     

    If this post helps, then consider Accepting it as the solution to help other members find it faster.

     

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
5 years ago

Hi,

There should be a simple measure to sum up the hours and divide by 8.

jsangerman's avatar
jsangerman
Icon for Helper II rankHelper II
5 years ago

Seems like it should be simple. Our team needs to know the data a little differently: 1) the data should be normalized to 8 daily hours, such that a person who works 12 hours in a day still counts for 1 FTE for that day; 2) we want to be able to exclude some projects using filters, such that a person who works 4 hours on Project A and 4 hours on Project B will count as 1 FTE when we filter Project B out of a visualization.