Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
Joynul
Frequent Visitor

Splitting data over months when using week commencing to define capacity

Hi, 


I am currently working on creating a capacity report, but I am having an issue where by my data pulls in the number of days a user has worked during week commencing X, but when the week commencing towards the end of the month and a new month starts mid week, my report double count, to avoid this I am trying to look for a way to say if a user works 5 days on a project on the week commencing 28/08/23. then the calculation would be able to say that he worked on the project on the 

28/08/23 - 01/09/23, which ,means I could get the report to show the user worked 4 days in August and 1 day in September, 

whereas another user who worked 4 days on the same project on the 28/08/2023 then it would only show the first four days i.e  28/08/23 - 31/08/23

 

Just to add the data only shows the number of days an employee works on a project within a week, it doesn't break the down to the exact day that the employee worked, hence why I am looking into this workaround

 

This is an example of the current data set that I am working with

 

Max_days.NameWeek_CommWrkd_DaysIndexind_wrk_weekDays_WorkedRemaining_Capacity
Employee Name 128-Aug-232.015.00.00.0
Employee Name 128-Aug-233.025.00.00.0
Employee Name 2 28-Aug-233.034.00.01.0
Employee Name 228-Aug-231.044.00.01.0
Employee Name 106-Jun-2215104
Employee Name 225-Jul-2246401
Employee Name 3 01-Aug-2247040
Employee Name 408-Aug-2248401
1 REPLY 1
lbendlin
Super User
Super User

- Months and Weeks are not compatible

- Use your Calendar table to spell out exactly what you mean by Month, Week, Workday, Holiday etc. Good luck if your users are in different countries/time zones.

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors