Return only last date

Question

I have the data as shown below:&nbsp;Entity IdCovenant IDCovenant Sub TypeTaskIDLatest Comment Date21632312108Net Interest Cover3849911/11/202021632312108Net Interest Cover3849902/11/202021632312109Leverage Ratio3850811/11/202021632312109Leverage Ratio3850802/11/202021632312110Capital Expenditure3851702/11/202021632312110Capital Expenditure3851711/11/2020&nbsp;for each covenant ID and task ID I only want to show the last 'Latest Comment Date'.&nbsp;For instance if you look at Task ID&nbsp;38499 I only want to see the&nbsp;'Latest Comment Date' as&nbsp;02/11/2020&nbsp;&nbsp;This is the measure I used.&nbsp;&nbsp;LAST DATE =&nbsp; calculate(max(VwCovenant[CovenantCommentsTimestamp]), filter(VwCovenant, VwCovenant[CovenantCommentsTimestamp] = calculate(max(VwCovenant[CovenantCommentsTimestamp]), allexcept(VwCovenant, VwCovenant[TaskID]))) )&nbsp;And it is returning a blank columnEntity IdCovenant IDCovenant TypeCovenant Sub TypeTaskIDDays OverdueLatest CommentCovenantCommentsTimestampLAST DATE21632312108Financial CovenantNet Interest Cover38500-26Covenant returned for amendments. Reason: Capture as Net interest cover, covenant sub type .11/11/2020&nbsp;21632312108Financial CovenantNet Interest Cover38500-26Covenant returned for amendments. Reason: Quarterly except FYE(march) .02/11/2020&nbsp;21632312108Financial CovenantNet Interest Cover38501-208Covenant returned for amendments. Reason: Capture as Net interest cover, covenant sub type .11/11/2020&nbsp;21632312108Financial CovenantNet Interest Cover38501-208Covenant returned for amendments. Reason: Quarterly except FYE(march) .02/11/2020&nbsp;&nbsp;&nbsp;But the last date is comming up empty.&nbsp;I'm not sure how to correct this.&nbsp;&nbsp;Annemie

amitchandak · Answer

Annemie19 , create measures like this
&nbsp;
Last Comment = calculate(max(Table[Comment]), filter(Table, Table[Comment Date] = calculate(max(Table[Comment Date]), allexcept(Table, Table[TaskID]))) )

annemie19 · Answer

amitchandak&nbsp;, this is still giving me a blank value

amitchandak · Answer

Annemie19 , Check if the attached file after signature can help 
&nbsp;

Forum Discussion

Return only last date

3 Replies

Related content

Measure returning incorrect value

Date Different return wrong value

MAXX Returning duplicate values

FORMAT() returns Month Number

List.Zip Returning an error

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

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