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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

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
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

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

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors