Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Converting Hours to FTEs

Hello,    I am using Power bi project online template is it possible to convert y axis value(days) to show FTE ?          Thanks Neringa  
verting H
Fowmy's avatar
Fowmy
Icon for Super User rankSuper User
6 years ago

Anonymous 

Then you can divide Total Hours by 8 if a day is considered 8 hours of work.

________________________

If my answer was helpful, please consider Accept it as the solution to help the other members find it

Click on the Thumbs-Up icon if you like this reply 🙂

YouTube  LinkedIn

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Fowmy  I have done that, it gives a number of days per month, I can change it into weeks, months etc,  however what 1 FTE equals to differs  month by month ( as the number of (working) days is different each month ) therefore I am not sure how to figure that bit out. 

  • Fowmy's avatar
    Fowmy
    Icon for Super User rankSuper User
    6 years ago

    Anonymous 

     

    Can you share some sample data and the expected result to have a clear understanding of your question?
    You can save your files in OneDrive, Google Drive, or any other cloud sharing platforms and share the link here.
    ____________________________________
    How to paste sample data with your question?
    How to get your questions answered quickly?

    _____________________________________
    Did I answer your question? Mark this post as a solution, this will help others!.

    Click on the Thumbs-Up icon if you like this reply 🙂

    YouTube, LinkedIn

  • plansis's avatar
    plansis
    Regular Visitor
    3 years ago

    FTE is a more complex measure as it is semi-aditive - you cannot drill down across a time dimension. 

    there is an easy work around for some scenarios:

    so , if your duration field is in hours, you can define three measures/or sql fields:

     

    ,duration /8 as duration_day_fte
    ,duration /38 as duration_week_fte
    ,duration / (38*T.month_days/7) as duration_month_fte
     
    We use 38 hours FTE week, so i divide number of days in the month by 7 to get exact decimal number of weeks. T is my time dimension, where each day also has number of days. 
     
    There are solutions to avoid 3 measures and use just one, but you will need DAX/SSAS calculations to find at what time level you are, it can be tricky if you want to expand/collaps time levels / month into days.
     
    you can use mine time dimension if you like