Distribute task hours in months

Question

Hello!When extracting data from Project Web, I can only see the distribution of hours by months accumulated in the month in which the task ends, but what I would need is to distribute the hours equally during the months it lasts.For example here you see 3 tasks one of them has 312 hours of effort and in the table points them to the month of July 2024.    Any idea how to do it?

amitchandak · Answer

Syndicate_Admin , refer if these can help 
Measure wayPower BI Dax Measure- Allocate data between Range: https://youtu.be/O653vwLTUzMhttps://community.powerbi.com/t5/Community-Blog/How-to-divide-distribute-values-between-start-date-or-end-date/ba-p/1503785
&nbsp;
Matrix as Project plan Visual: https://youtu.be/R25QoiyoSVs

Forum Discussion

Distribute task hours in months

1 Reply

Related content

If current month hours are blank, then use previous month hours instead

Hours Distribution Start to End

Hour Calculation

PQ -Date Distribution

Distributing Hours over Months using START/END dates/time.