Forum Discussion

ElliotK's avatar
ElliotK
Helper I
4 years ago
Solved

Create new column for MAXDate

Hello,   I wish to create a column that calculates that Max Data where the TaskPosition is "Completed" for TaskGroupID 13, within eID 53.    ID eID TaskGroupID TaskStatusID TaskStatus Sta...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi ElliotK ,

     

    Please try

    Column = CALCULATE(MAX('Table (2)'[EndDate]),FILTER('Table (2)',[TaskPosition]="Completed"&&[eID]=EARLIER('Table (2)'[eID])))

     

     

     

    Best Regards,

    Stephen Tao

     

    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
4 years ago

Hi ElliotK ,

 

Please try

Column = CALCULATE(MAX('Table (2)'[EndDate]),FILTER('Table (2)',[TaskPosition]="Completed"&&[eID]=EARLIER('Table (2)'[eID])))

 

 

 

Best Regards,

Stephen Tao

 

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