Forum Discussion

walker8888's avatar
walker8888
Helper II
1 year ago
Solved

Resource Capacity Report FTE (Full Time Equivalent) Measure

Hi,

 

I need help with having a measure that will update my resource capacity over time section. I want this measure to calculate anything that is over 40 hrs in a work week into FTE's (Full time equivalent) For example if there was a group in the organization that have 4 employees and each worked 50 hours per week, that will show that the group is working over capacity by 1 FTE. I also want the measure to auto calculate so measure  weeks, months and years. Can someone help me with this? Thanks!

 

 

General Comment
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • v-achippa's avatar
    v-achippa
    1 year ago

    Hi walker8888,

     

    Thank you for reaching out to Microsoft Fabric Community.

     

    To calculate FTE (Full-Time Equivalent) based on a work week over 40 hours, we can create a measure that compares the total hours worked against the full-time equivalent hours (40 hours per week) and translates that into FTEs.

     

    Here's the DAX to build this measure

     

    FTE =  
    VAR Total_Hours_Worked = SUM('EmployeeData'[HoursWorked])  
    VAR Employees_Count = DISTINCTCOUNT('EmployeeData'[EmployeeID]) 
    VAR FTEs = Total_Hours_Worked / (Employees_Count * 40)
    RETURN FTEs

     

     

    If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it! 

     

    Thanks and regards,

    Anjan Kumar Chippa

1 Reply

  • v-achippa's avatar
    v-achippa
    Community Support
    1 year ago

    Hi walker8888,

     

    Thank you for reaching out to Microsoft Fabric Community.

     

    To calculate FTE (Full-Time Equivalent) based on a work week over 40 hours, we can create a measure that compares the total hours worked against the full-time equivalent hours (40 hours per week) and translates that into FTEs.

     

    Here's the DAX to build this measure

     

    FTE =  
    VAR Total_Hours_Worked = SUM('EmployeeData'[HoursWorked])  
    VAR Employees_Count = DISTINCTCOUNT('EmployeeData'[EmployeeID]) 
    VAR FTEs = Total_Hours_Worked / (Employees_Count * 40)
    RETURN FTEs

     

     

    If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it! 

     

    Thanks and regards,

    Anjan Kumar Chippa