Showing results for 
Search instead for 
Did you mean: 
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

PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

MPPC 2023 PBI Carousel

Power Platform Conference-Power BI and Fabric Sessions

Join us Oct 1 - 6 in Las Vegas for the Microsoft Power Platform Conference.

Top Solution Authors