Distribute task hours in months

[Syndicate_Admin]

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]

@Syndicate_Admin , refer if these can help

Measure way
Power BI Dax Measure- Allocate data between Range: https://youtu.be/O653vwLTUzM
https://community.powerbi.com/t5/Community-Blog/How-to-divide-distribute-values-between-start-date-o...

Matrix as Project plan Visual: https://youtu.be/R25QoiyoSVs