topic Re: Converting Hours to FTEs in DAX Commands and Tips

Converting Hours to FTEs

Anonymous — Tue, 22 Sep 2020 18:23:23 GMT

Hello,

I am using Power bi project online template is it possible to convert y axis value(days) to show FTE ?

Thanks

Neringa

Re: Converting Hours to FTEs

Fowmy — Tue, 22 Sep 2020 19:52:42 GMT

Anonymous

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 it

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

YouTube LinkedIn

Re: Converting Hours to FTEs

Anonymous — Wed, 23 Sep 2020 08:20:50 GMT

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

Re: Converting Hours to FTEs

Fowmy — Wed, 23 Sep 2020 08:43:25 GMT

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

Re: Converting Hours to FTEs

Anonymous — Wed, 23 Sep 2020 08:54:11 GMT

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.

Re: Converting Hours to FTEs

Fowmy — Wed, 23 Sep 2020 09:17:52 GMT

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

Re: Converting Hours to FTEs

plansis — Fri, 21 Apr 2023 14:44:27 GMT

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

https://github.com/maximnl/time_date_dimensions/blob/main/A_TIME_DATE_DATA.sql