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
