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
Hello, Fab117 .
The StartDate and EndDate for sake of readability is a function.This function have couple steps that will be proceed when this function it's called. Both of them are based on the intital table which is the Key variable (step).
What I do for each is to based on the [key] I sort it either by StartDate or EndDate Asc or Desc and then Buffer it to keep the sorting in memory (if you don't buffer, the engine will ignore the sort when you want to remove duplicates etc)., then I remove the duplicates based on the key, so for each project and phase I have single date.
After that I join these two new columns one by one to the original table (key variable). and then I proceed with the other steps.Did it clarify the solution for you?