Forum Discussion
How to split total hours in available weeks
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
2 Replies
- amitchandak
Super User
Anonymous , I have done a blog to divide it across days, See if you can use that for week
