Create a measure for gantt chart help

[Anonymous]

Hello Power Users,

I'm trying to create a measure for gantt chart for below data. the senorio would be the Previous Milestone and Previous Milestone planned date would be the columns that use to create the measure. The data is grouped by “Name” i.e Column-1 Within each Name we would need the milestone name and date from the previous milestone.

Please help

[Anonymous · Accepted solution]

Hi @Anonymous ,

Sorry for that the information you have provided is not making the problem clear to me.

If you want to get the End Date based on the next Previous Milestone planned date of each Name, please try:

End Date Measure = MINX(FILTER(ALLSELECTED('Table'),[Name]=MAX('Table'[Name]) && [Previous Milestone planned date]>MAX('Table'[Previous Milestone planned date])),[Previous Milestone planned date])

If not,please share more details to help us clarify your scenario.

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