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

“have each task (of which they can have multipule per day) and the time allocated to that task merge into one”

Calculate the total time allocated to each task 

 

"have it show as a percentage of time that's been allocated to that task for the month alongside the percentages against the other tasks"

Calculate the time of each range (annual leave, on call, training, etc) for each task,

For example, the percentage should be(in a month level)

Total time of annual leave for task1/ Total time of annual leave for all tasks

 

"And to then also have one set up to show each persons (or group of people) time against certain tasks, as a percentage of utilization"

Percentage:

Total time a person taking/ total time of certain tasks which the person takes part in

 

How does the dataset including all columns and tables will be applied above looks like?

 

Best Regards

Maggie

smather's avatar
smather
Helper III
8 years ago

Hi v-juanli-msft

 

Thanks for replying! :)

 

Apologies for sounding stupid, but I'm still in the playing around stages of Power BI -- how would I go about calculating the total time allocated to each task in Power BI, or is that something best done in Excel first? 

 

Many thanks

  • v-juanli-msft's avatar
    v-juanli-msft
    Community Support
    8 years ago

    Hi smather

    You can both calculate total in excel or power bi,Power BI provide many DAX functions to do that.

     

    Best Regards

    Maggie