Forum Discussion
Monthly FTE (Fulltime Equivalent) headcount reporting when employees change status in the month
Hi ashnoti ,
I don't quite understand your needs , please provide some sample data in your tables (exclude sensitive data) with Text format and your expected result with backend logic and special examples. It is better if you can share a simplified pbix file. Thank you.
Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Neeko Anonymous
Thank you for your reply and I apologise for the delay in getting back to you.
Pibx:Labour Report.pibx
Data:Labour Data.xlsx
Have a look at employee 444009 - they changed from Casual to Part Time and then back to Casual in October.
I would like for the report to show this person as Casual as most of the hours in October were casual hours; like this:
| Sep | Oct | Total | |||||||||||
| Labour Goup | Employee | Work Days | Total Hrs | FTE-Non Perm | FTE - Perm | Work Days | Total Hrs | FTE-Non Perm | FTE - Perm | Work Days | Total Hrs | FTE-Non Perm | FTE - Perm |
| Casual | 444009 | 25 | 147 | 0.77 | 20 | 79.25 | 0.52 | 45 | 226 | 0.66 |
Also I would like to have just one column for FTE that shows Distinctcount of Employee ID if Perm and [Total Hours]/(Work Days * 7.6) if not Perm:
| Sep | Oct | Total | ||||||||
| Labour Goup | Employee | Work Days | Total Hrs | FTE | Work Days | Total Hrs | FTE | Work Days | Total Hrs | FTE |
| Casual | 444009 | 25 | 147 | 0.77 | 20 | 79.25 | 0.52 | 45 | 226 | 0.66 |
| Perm | 444019 | 25 | 193.75 | 1 | 20 | 152 | 1 | 45 | 345.75 | 1 |
Does this help?