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
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