Forum Discussion

smather's avatar
smather
Helper III
8 years ago

Data Consolidation - Combine Timesheet Data

 Hi all    Totally new to this and have no idea what I'm doing, so if anyone could help that would be great.    Trying to consolidate data from timesheets -- they have five tasks per day that ran...
Need Help
Show and Tell
v-juanli-msft's avatar
v-juanli-msft
Community Support
8 years ago

Hi smather

Could you show me some data example and what result you want?

For axample,

calculating the total time allocated to each task = 
CALCULATE(SUM(Sheet1[time]),ALLEXCEPT(Sheet1,Sheet1[tasks]))

 

Best Regards

Maggie

smather's avatar
smather
Helper III
8 years ago

Hi v-juanli-msft

 

this is the data I've got -- some of the tasks (like install) have a job reference allocated to it, so eventually I'd like to be able to sort on how many hours per task type was spent on a job, but I'm not even over this hurdle yet -- thanks for the hand holding.

 

This is how the data comes through, I'm not sure why task 2 and task 3 for example have blank things at the top with time associated with them, because it's not like that on the timesheet. 

 

Whenever I try to put them together, it seems to sort on task 1 and then task 2 on how many times it's shown up on task 1? I don't know what's going on there. I'm not sure why Task 3 to 5 aren't grouping together either. 

 

 

Many thanks :)