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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

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
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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

Top Solution Authors