How to create a schedule start and end date for task list when there are parallel tasks ?

[Poova]

I have a Sharepoint list with the below format:

Task ID	Task description	Resource	Days required	Start Date	Projected completion
1	Task 1	A	10	2023-01-05 (example)	CALCULATED
2	Task 2	B	20	2023-01-02 (example)	CALCULATED
3	Task 3	A	30	CALCULATED	CALCULATED
4	Task 4	B	40	CALCULATED	CALCULATED
5	Task 5	Unassigned	10	CALCULATED	CALCULATED

This is not a major project but individual service requests which are independent of each other. Each resource has only 5 hours per day to work. 

Based on this, I want to auto populate the start and end date of the following tasks.  I am stuck at how do I calculate the start and end dates for the tasks that are unassigned? In this case what could be a better approximation to show the completion schedule of all pending tasks that are unassigned

I am new to power BI and still learning DAX . Any help would be appreciated

[v-rongtiep-msft · Accepted solution]

Hi @Poova ,

I have created a simple sample, please refer to my pbix file to see if it helps you.

Create columns.

startdate = MAXX(FILTER(ALL('Table'),'Table'[Resource]=EARLIER('Table'[Resource])),'Table'[Start Date])

projectcompletion = var _1= 'Table'[startdate]+'Table'[Days required]
return
IF('Table'[Start Date]=BLANK()&&'Table'[startdate]=BLANK(),BLANK(),_1)

How to Get Your Question Answered Quickly 

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards
Community Support Team _ Polly

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.