cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
MichaelSX Frequent Visitor
Frequent Visitor

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 entries. Each entry has the Project Number, Start Date, End Date and Duration. I've been able to make a line chart that shows how much time was spent on each project per month, but I want each month to include the running total up to that point. This table is set up to be filtered to a single project at a time.

 

I also have another table that has the project number and an estimate for how long each project is supposed to take. I want to display the estimate for whichever project the page is currently filtered to on the same chart, but I've only been able to work with the sum/average/etc of the column.

1 ACCEPTED SOLUTION

Accepted Solutions
MichaelSX Frequent Visitor
Frequent Visitor

Re: total hours to date per project

I figured it out after reading this post. The solution is to use a quick filter for year to date

View solution in original post

4 REPLIES 4
Super User
Super User

Re: total hours to date per project

Hi,

 

Share the link from where i can download your PBI file.  Also show the expected result there.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
Highlighted
opticshrew Member
Member

Re: total hours to date per project

Hi @MichaelSX

 

How is your data structured? Is it as follows?

 

Projects > Appointments (time associated with a project)

 

Additionally what is your data source?

 

Thanks,

J

MichaelSX Frequent Visitor
Frequent Visitor

Re: total hours to date per project

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.

MichaelSX Frequent Visitor
Frequent Visitor

Re: total hours to date per project

I figured it out after reading this post. The solution is to use a quick filter for year to date

View solution in original post

Helpful resources

Announcements
October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Badges

Incoming: New and Improved Badges

Exciting news: We've given our badges an overhaul and added brand news ones.

Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Users Online
Currently online: 146 members 1,735 guests
Please welcome our newest community members: