Forum Discussion
Extract Date based on Data Condition
Hi All, I am trying to create a gantt chart to show which people are working on which projects over time and the duration they are working on them. The data doesn't currently contain a start and ...
Hi Anonymous ,
Please try:
Start Date = MINX(FILTER('Table',[Employee No]=EARLIER('Table'[Employee No])&&[Project]=EARLIER('Table'[Project])&&[Demand (FTE)]<>0),[Month Date]) End Date = MAXX(FILTER('Table',[Employee No]=EARLIER('Table'[Employee No])&&[Project]=EARLIER('Table'[Project])&&[Demand (FTE)]<>0),[Month Date])Final output:
Best Regards,
Jianbo Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous ,
Please try:
Start Date = MINX(FILTER('Table',[Employee No]=EARLIER('Table'[Employee No])&&[Project]=EARLIER('Table'[Project])&&[Demand (FTE)]<>0),[Month Date])
End Date = MAXX(FILTER('Table',[Employee No]=EARLIER('Table'[Employee No])&&[Project]=EARLIER('Table'[Project])&&[Demand (FTE)]<>0),[Month Date])Final output:
Best Regards,
Jianbo Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you!