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.
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 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
What measure can I write for this?
Kind Re
Same problem with me I have project and each project have multiple task and its task completion date I want to show latest task based on latest date in power bi could any one help me
@amitchandak, Thanks for the help.
However, 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 |
@Annemie19 , Create a measure like
Last Date = calculate(max(Table[Latest Comment Date]), filter(Table, Table[Latest Comment Date] = calculate(max(Table[ Latest Comment Date]), allexcept(Table, Table[TaskID]))) )
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 |
---|---|
47 | |
24 | |
20 | |
15 | |
12 |
User | Count |
---|---|
55 | |
48 | |
43 | |
19 | |
18 |