Return only last date

Annemie19 — Wed, 03 Feb 2021 15:22:58 GMT

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

Re: Return only last date

amitchandak — Wed, 03 Feb 2021 15:41:10 GMT

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

Re: Return only last date

Annemie19 — Wed, 03 Feb 2021 16:04:01 GMT

amitchandak , this is still giving me a blank value

Re: Return only last date

amitchandak — Wed, 03 Feb 2021 16:13:02 GMT

Annemie19 , Check if the attached file after signature can help

topic Re: Return only last date in DAX Commands and Tips

Return only last date

Re: Return only last date

Re: Return only last date

Re: Return only last date