Forum Discussion
Solved
total hours to date per project
I'm trying to set up a graph that shows the total amount of time spent on a project each month, including all time up to that point. I have one table that contains all of our employee's time entr...
TBH I didn't mean to post this yet. I managed to solve some of my issues on my own. The one remaining problem is making the total hours to date filtered by project. I can't post my workbook because it contains personal data about my company and its employees. I'm reading from an excel file with columns: Project, Duration, Start Time, End Time and Total Time. I've set up a Line Chart with Total Time on the axis and the following measure ToDate:
ToDate = CALCULATE(SUM(Toggl[Duration (Hours)]),FILTER(All(Toggl),Toggl[Month]<=MAX(Toggl[Month])))
Month = Month(Toggl[Start Date])
This results in the total sum of Duration accross all projects. I want it to be filtered by a project chosen by a slicer.