In our Project Online environment, we have project-level fields to capture Cost Centers (CC#'s 1-10)
And for each Cost Center that is added to the project, a field that allocates the percentage to the corresponding cost center is used.
We want to be able to allocate each resource's timesheet actual work hours to appropriate Cost Centers for each scenario:
What is the best way to show each timesheet line with allocated actual work hours by project task?
What does the original data look like? Can you share it? To be honest, your requirement here seems easy. It could be [work hours] * [percentage].
I would think the calculation would be easy enough, but how would I take one resource's timesheet line with actual work hours to split it into multiple lines that have the percentages allocated to each cost center accordingly?
Here is a link to my .pbix file: PBI End Month Report
Please don't share sensitive data here.
I would suggest you do some adjustments in the table [Projects]. Please refer to the attachment for details, the new table [Projects_new].
Measure = SUM(TimesheetLines[Actual Work]) * sum(Projects_new[CC_P_Value])
This is great to allocate project cumulative actual work by cost center, but what I am trying to accomplish at the timesheet line level is to display a table showing all timesheet lines in a certain month that splits the resources' actual work for a project based on the cost center and number of cost centers using the CCPercent fields.
Using your example for the 0620 PR Complex project with the following cost center percentage allocations:
Instead of showing a cumulative view of actual work for the project by cost center:
Display a table that takes a resource's actual work from timesheets and split them into separate lines for each cost center from this:
And just to throw a big wrench into the mix... If the 0620 PR Complex project schedule's task, Conduct needs analysis, has a task-level field that is not blank (field name: Task Cost Center), the entire actual work for that task would be allocated to the cost center that is listed in the Task Cost Center field and ignore the project-level cost centers. So all other tasks in the 0620 PR Complex project that has actual work reported would follow the allocations at the project-level, but the tasks where the Task Cost Center is not blank would have actual work allocated to the one cost center in that task-level field.
What is the best way to accomplish this?