Calculated date is showing only earliest date instead of all dates

[shefalinishad11]

Hi All,

I have created a calculated column to get the project task end date from the start date. The next Project task start date is the end date for the current task. I even get by default the date hierarchy of that column. But now, while plotting the same in Gantt chart, the project end date is only picking the earliest one date instead of whole end date series. 

EndDate = 
VAR Project = FY21[Project Name]
VAR TaskStartDate = FY21[Start Date]
VAR nextTaskDate = 
MINX(
FILTER(FY21, FY21[Project Name] = Project
&& FY21[Start Date] > TaskStartDate
),
FY21[Start Date]
)
Return
IF(ISBLANK(nextTaskDate), TaskStartDate, nextTaskDate)

[v-easonf-msft]

Hi , @shefalinishad11 

Start date filed defines the position of task progress.Duration defines the width of task progress.

It is suggested  to use 'Start date' and 'Duration' rather than 'Start date' and 'End Date'  to create Gantt chart.

Please add another calculated column as below:

Duratation = DATEDIFF('FY 21'[Start Date],'FY 21'[End Date],DAY)

Please check my sample pbix for more details.

Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@shefalinishad11 ,Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.