Forum Discussion
Solved
Calculating end date and duration for multiple tasks AND multiple projects
Hi PBI experts! I'm trying to calculate the end date and duration (between those two dates) for multiple projects that have multiple tasks within themselves. My table looks like: In the proje...
vivi_nainai2021 , You can create a new column like
End date = Minx(filter(Table, [Project name] =earlier([Project name]) && [Start Date] > earlier([Start Date]) ), [Start Date])
Diff in days = datediff([Start date],[End Date], day)
vivi_nainai2021 , You can create a new column like
End date = Minx(filter(Table, [Project name] =earlier([Project name]) && [Start Date] > earlier([Start Date]) ), [Start Date])
Diff in days = datediff([Start date],[End Date], day)
Thank you amitchandak , but I'm not getting the output I need. This is what I get but I need the start date of a succeeding task to the be end date for the previous one:
Can the previous formula be tweaked?