Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more
Hello,
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.
Created | DID | Demand Substatus |
2/4/2019 1:07:17 PM | DOH-1252 | Under Pre-Tender Input (User, Legal, Proc., Finance, DPO) |
4/16/2019 12:33:29 PM | DOH-1252 | Under Contract Drafting & Finalization (Proc., Legal, TNO, Finance, DPO, Vendor) |
5/16/2019 11:22:53 AM | DOH-1252 | Under Contract Drafting & Finalization (Proc., Legal, TNO, Finance, DPO, Vendor) |
5/16/2019 11:25:02 AM | DOH-1252 | Draft |
5/20/2019 11:32:37 AM | DOH-1252 | Draft |
5/20/2019 11:34:34 AM | DOH-1252 | Draft |
5/20/2019 12:36:39 PM | DOH-1252 | Draft |
12/17/2018 12:02 | DOH-1122 | Pending Manager Approval |
If anyone can help with this, it will be very helpful.
Link to the excel file is this:
https://drive.google.com/drive/folders/1ywzrvyU_0O6Pjz2CuDV417JIpsmy0XQL?usp=sharing
Thanks a lot in advance
@naeemf , refer these approches. You might need min, inplace of max
https://amitchandak.medium.com/power-bi-get-the-last-latest-value-of-a-category-d0cf2fcf92d0
Check out the April 2025 Power BI update to learn about new features.
Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.
User | Count |
---|---|
98 | |
61 | |
47 | |
36 | |
34 |