Return only last date

[Annemie19]

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 Cover	38499	02/11/2020
21632312	109	Leverage Ratio	38508	11/11/2020
21632312	109	Leverage Ratio	38508	02/11/2020
21632312	110	Capital Expenditure	38517	02/11/2020
21632312	110	Capital Expenditure	38517	11/11/2020

for each covenant ID and task ID I only want to show the last 'Latest Comment Date'. 

For instance if you look at Task ID 38499 I only want to see the 'Latest Comment Date' as 02/11/2020

This is the measure I used. 

LAST DATE =  calculate(max(VwCovenant[CovenantCommentsTimestamp]), filter(VwCovenant, VwCovenant[CovenantCommentsTimestamp] = calculate(max(VwCovenant[CovenantCommentsTimestamp]), allexcept(VwCovenant, VwCovenant[TaskID]))) )

And it is returning a blank column

Entity Id	Covenant ID	Covenant Type	Covenant Sub Type	TaskID	Days Overdue	Latest Comment	CovenantCommentsTimestamp	LAST DATE
21632312	108	Financial Covenant	Net Interest Cover	38500	-26	Covenant returned for amendments. Reason: Capture as Net interest cover, covenant sub type .	11/11/2020
21632312	108	Financial Covenant	Net Interest Cover	38500	-26	Covenant returned for amendments. Reason: Quarterly except FYE(march) .	02/11/2020
21632312	108	Financial Covenant	Net Interest Cover	38501	-208	Covenant returned for amendments. Reason: Capture as Net interest cover, covenant sub type .	11/11/2020
21632312	108	Financial Covenant	Net Interest Cover	38501	-208	Covenant returned for amendments. Reason: Quarterly except FYE(march) .	02/11/2020

But the last date is comming up empty. 

I'm not sure how to correct this. 

Annemie

[amitchandak]

@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]

@amitchandak , this is still giving me a blank value

[amitchandak]

@Annemie19 , Check if the attached file after signature can help