Create a Forecast graph of the hours/FTE per month given project start date, end date and hours

[cmontoure22]

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:

• Calculate the working days between Start Date and End Date
• Distribute the hours per month by on the # of working each month
• The two graphs below would be the output I'm looking for.

Thoughts on the approach to this?

[amitchandak]

@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.

[cmontoure22]

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