Converting Hours to FTEs

Question

Hello,&nbsp;&nbsp;I am using Power bi project online template is it possible to convert y axis value(days) to show FTE ?&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;ThanksNeringa&nbsp;

anonymous · Answer

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

fowmy · Answer

Anonymous&nbsp;You need to add a custom column that divides [Days] by your FTE days, then that column can be added to the chart instead of the DAys column.________________________If my answer was helpful, please consider Accept it as the solution to help the other members find itClick on the Thumbs-Up icon if you like this reply 🙂YouTube&nbsp; LinkedIn

anonymous · Answer

Thanks&nbsp;Fowmy&nbsp; the problem is that I do not have values for FTE's&nbsp; and I am not sure how to determine the value as i only have hours per day worked and date and time table.&nbsp;

fowmy · Answer

Anonymous&nbsp;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 itClick on the Thumbs-Up icon if you like this reply 🙂YouTube&nbsp; LinkedIn

fowmy · Answer

Anonymous&nbsp;&nbsp;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

Forum Discussion

Converting Hours to FTEs

6 Replies

Related content

Convert minutes into hours

Hour Calculation

Convert number of minutes to hours

Convert time hour to minutes

Convert Number into hours and minutes