How to split total hours in available weeks

[Anonymous]

Hi Team,

I have split total hours into available weeks.  Example:- In the below image on the 1st row. To weeks count including start_wk and End week.  The total hours is 16. I have to split (8 hours for 20 week+ 8 hours for 21 week = 16 hours) . How I can calculate and show in power bi.

link for raw data:-https://1drv.ms/x/s!An_X5mJMyo_BcCGrZouYbERM6B4?e=uJe4AG 

[Anonymous]

Hi @Anonymous ,

Is your expected result the Total Hours column? 

Please explain it in more detail.

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Anonymous , I have done a blog to divide it across days, See if you can use that for week

https://community.powerbi.com/t5/Community-Blog/How-to-divide-distribute-values-between-start-date-or-end-date/ba-p/1503785