Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Timesheet data - visualise specific activity in each month

Hi,   I have a dataset of timesheet data, relevant columns are:   Entry Date - date of time entry e.g. 26 July 2018 Hours Worked- time spent on an activity - decimal hours Task User Name - deta...
Need Help
Tips and Tricks
MFelix's avatar
MFelix
Icon for Super User rankSuper User
7 years ago

Hi Anonymous,

 

You need to create a measure to calculate this:

 

hours =
SUM ( Timesheet[Hours Worked] )
    / CALCULATE (
        SUM ( Timesheet[Hours Worked] );
        ALL ( Timesheet[Month Year]; Timesheet[Task User Name] )
    )

Without any data example is difficult to give you a better answer.

 

Chan you share some sample data and expected result?

 

Regards,

MFelix

Anonymous's avatar
Anonymous
Not applicable
7 years ago

 

Hi MFelix

 

Thanks for replying.

 

Sample data attached. 

 

I don't understand how that measure will help me to find the monthly total for each month and then

allow me to use that in later calculations?

 

Thanks,

 

James