Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
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
@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 , Check if the attached file after signature can help
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
49 | |
26 | |
21 | |
16 | |
12 |
User | Count |
---|---|
57 | |
49 | |
44 | |
19 | |
18 |