Forum Discussion
Get latest date for certain task ID
Hi, 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 In...
amitchandak, Thanks for the help.
However, 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 |