Skip to main content
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

New Member

Need help regarding calculating earliest last status of a record



I have demand updates table which logs all the updates for each demand. I want to keep latest update record of each demand in a new table. Problem is that even if a user adds comments for a demand, the status stays the same but a new line record is added with new timestamp. In such cases, I would like to keep the last substatus change record.


Below is an example table. The demand DOH-1252 has been updated as draft "4" times. In this case I would like to keep the record with date. e.g. "5/16/2019 11:25:02 AM" as my last sub-status update record. In case of DOH-1122 data would be fetched as it is because there are no substatus duplications.


CreatedDIDDemand Substatus
2/4/2019 1:07:17 PMDOH-1252Under Pre-Tender Input (User, Legal, Proc., Finance, DPO)
4/16/2019 12:33:29 PMDOH-1252Under Contract Drafting & Finalization (Proc., Legal, TNO, Finance, DPO, Vendor)
5/16/2019 11:22:53 AMDOH-1252Under Contract Drafting & Finalization (Proc., Legal, TNO, Finance, DPO, Vendor)
5/16/2019 11:25:02 AMDOH-1252Draft
5/20/2019 11:32:37 AMDOH-1252Draft
5/20/2019 11:34:34 AMDOH-1252Draft
5/20/2019 12:36:39 PMDOH-1252Draft
12/17/2018 12:02DOH-1122Pending Manager Approval


If anyone can help with this, it will be very helpful. 


Link to the excel file is this:
Thanks a lot in advance




Helpful resources

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.


Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.