Forum Discussion
Monthly workload summing each phase from each project
Hello, Fab117,
I think I got you:Btw I think I found some issues in your calculations as 31-3 = 28 but it's not 93% but 90% but other than that it seems working. Based on your example.
Here's the file:
Hello, Fab117,
I think I got you:
Btw I think I found some issues in your calculations as 31-3 = 28 but it's not 93% but 90% but other than that it seems working. Based on your example.
Here's the file:
Big thank you for spending time on my challenge.
Your proposal is great. I was not expecting to look for the solution in Power Query, but why not.
After deep review (I'm quite new in Power BI), I think I understood all your steps up to the result.
I'll now try to apply to my specific case.
Have a nice week.
Fab
Well, it's easier to have a physical table for this kind of stuff because doing it in DAX would be just a pain 😄
Happy to help, kudos are appreciated. Lemme know if you need some steps better explained.Hi vojtechsima,
I've been able to manage up to creation of the "key" column:
I then understand that for each different [key], you'll identify oldest [start date] and latest [Due date] through steps "startDate" and "endDate" which will result to the 2 new columns [earliestStartDate] and [latestDueDate] (that you'll then expand).
I don't understand what is behind steps "startDate" and "endDate" up to the 2 new columns creation and how to replicate in my particular case.
Could you please detail this part?
Regards,
Fab
