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

I can get the subtotals in a visualisation easily - I just want to use these montly substotals in further calculations!

 

Is there a way to refer to this table or can i create this table dynamically in an expression so i can set up a robust template?

 

Thanks,

 

James

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago
    MonthHours = CALCULATE(SUM('January 2019 (rolling 6)'[Hours Worked]),RELATED('January 2019 (rolling 6)'[MonthYear]))
     
    Trying to use this but there isn't a relationship...
     
    James