Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Dear kind Sir/Madam,
Imagine a table with four colums, actually dont imagine, just look below.
Key | Date/Time | Remaining | NEW |
6581 | 16/12/2020 05:34:33 | -1 | |
6581 | 19/12/2020 08:24:25 | 0,2 | |
6581 | 19/12/2020 12:54:23 | 3,2 | 3,2 |
7892 | 21/12/2020 10:24:23 | 3 | |
7892 | 24/12/2020 08:54:23 | 2 | 2 |
I would like to see the result like in the last column. So this new function I am looking for should first determine all the rows with the same "key". Then it should look at the corresponding "Date/Time" which date is the most recent (Can be an hour difference only). Then with the most recent date it should return the value from 'Remaining'. Resulting in a column like you can see in red.
I hope you are able to help me, thank you for the effort anyway.
Kind Regards.
Solved! Go to Solution.
@SearchKnowledge Try this and let me know how it goes: The working file is attached below my signature.
@SearchKnowledge Try this and let me know how it goes: The working file is attached below my signature.
@AntrikshSharma Thank you for your fast reply and effort, awesome! I only work on the project once a week. But I will try to test it this week. I will let you know!
User | Count |
---|---|
53 | |
46 | |
19 | |
16 | |
13 |
User | Count |
---|---|
108 | |
56 | |
31 | |
19 | |
18 |