Forum Discussion
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...
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
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