Forum Discussion

Annemie19's avatar
Annemie19
Icon for Helper II rankHelper II
5 years ago

Get latest date for certain task ID

Hi,    I have the data as shown below:   Entity Id Covenant ID Covenant Sub Type TaskID Latest Comment Date 21632312 108 Net Interest Cover 38499 11/11/2020 21632312 108 Net In...
Date
groupby
measure
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

Annemie19 , Create a measure like

 

Last Date = calculate(max(Table[Latest Comment Date]), filter(Table, Table[Latest Comment Date] = calculate(max(Table[ Latest Comment Date]), allexcept(Table, Table[TaskID]))) )