Forum Discussion

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

Return only last date

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 Interest Co...
Last date
measure
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

Annemie19 , create measures like this

 

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

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

amitchandak , this is still giving me a blank value