Showing results for 
Search instead for 
Did you mean: 
greemlin Frequent Visitor
Frequent Visitor

Average Man Days per month



I'm new on PowerBI, and I'm struggling to do the following, which is however pretty simple on excel:

  •  I've got a table AllActivitiesCSV which contains the list of activities the people of my team are working on. The Project Delivery name is mentioned in those activities when they are working on one (see picture here after):Capture d’écran 2016-12-29 à 12.13.45.png




  • I've got another table "PowerBI-Deliveries" which contains the list of the Delivery projects, the End Date of the project (when empty it means the project is still active), and the PS Days which may have been orderedCapture d’écran 2016-12-29 à 12.15.30.png



  • What i'd like to do is get the number of days spent on each of the finished project, calculated with an average on a monthly basis
  • I'd like also to take into account the PS Days ordered. For instance, if Delivery A has 10 PS days ordered, and we have spent 15 working on it, then i'd like to get 5 as a result

Since screenshot talks better than text, the final graph i'm aiming at is the following one, which has the average man days of the ended project, on a monthly basis.

Capture d’écran 2016-12-29 à 12.31.14.png


I'd be very happy if anyone could help me !

Thank you,




Super User
Super User

Re: Average Man Days per month

Can you send the sample data to me and I will provide you the solution? Ping me in private message and I will give you my email id.




Did I answer your question? Mark my post as a solution.

Proud to be a Datanaut! Kudos Help Smiley Happy
Connect with me on Linkedin. Feel free to email me with any of your BI needs.