Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

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 ...
Need Help
  • v-jianboli-msft's avatar
    v-jianboli-msft
    3 years ago

    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.

v-jianboli-msft's avatar
v-jianboli-msft
Community Support
3 years ago

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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Thank you!