Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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]))) )
User | Count |
---|---|
41 | |
27 | |
23 | |
18 | |
15 |
User | Count |
---|---|
54 | |
35 | |
19 | |
18 | |
15 |