Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello -
I'm looking to Forecast the number of Full Time Equivalent (FTE) of work given a list of Project Data: Start Date, End Date and Total Project Hours. The Green Columns below are what would be the inputs. I believe I need to:
Thoughts on the approach to this?
@cmontoure22 , for work day you use networkdays
Power BI - Business day with and without using DAX Function NETWORKDAYS: https://www.youtube.com/watch?v=Qs03ZZXXE_c
https://medium.com/@amitchandak/power-bi-dax-function-networkdays-5c8e4aca38c
For Business hours
https://exceleratorbi.com.au/calculating-business-hours-using-dax/
To distribute use this, use networkdays to get days of month and use filter of workday
Power BI Distributing/Allocating the Monthly Target(Convert to Daily Target): Measure ( Daily/MTD): https://community.powerbi.com/t5/Community-Blog/Power-BI-Distributing-Allocating-the-Monthly-Target-...
If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
Hello-
Thanks for that. I have the NETWORKING days working. If I multipy that times 8 = Net Working Hrs.
Each month's Net Working Hrs will equate to 1 FTE
How do I distribute Each Projects Total hours over each month between the Start and End Dates?
Each Project's Hours are based on Table 2 below by connecting theType and Size between each Table.
The goal is to get this this output, that can be filtered by Project Name, Type or Size
Project Info (Table 1)
Start Date | End Date | Project name | Project Type | Sizing |
1/1/23 | 10/1/23 | Project 1 | Type 1 | XL |
2/1/23 | 10/1/23 | Project 1 | Type 2 | XL |
3/1/23 | 10/1/23 | Project 1 | Type 3 | XL |
4/1/23 | 10/1/23 | Project 1 | Type 4 | XL |
5/1/23 | 10/1/23 | Project 1 | Type 5 | XL |
6/1/23 | 10/1/23 | Project 1 | Type 6 | XL |
4/1/23 | 3/1/24 | Project 2 | Type 1 | XL |
6/1/23 | 3/1/24 | Project 2 | Type 2 | XL |
8/1/23 | 3/1/24 | Project 2 | Type 3 | XL |
4/1/24 | 6/1/24 | Project 2 | Type 4 | XL |
4/1/24 | 6/1/24 | Project 2 | Type 5 | XL |
1/1/24 | 5/1/24 | Project 3 | Type 1 | XL |
1/1/24 | 6/1/24 | Project 3 | Type 2 | XL |
1/1/24 | 7/1/24 | Project 3 | Type 3 | XL |
Sizing (Table 2)
Project Type | Sizing | Hours |
Type 1 | XL | 500 |
Type 2 | XL | 250 |
Type 3 | XL | 500 |
Type 4 | XL | 500 |
Type 5 | XL | 1250 |
Type 6 | XL | 1250 |