topic Re: Filter, Then Sort, Then Select in DAX Commands and Tips

Filter, Then Sort, Then Select

SearchKnowledge — Wed, 09 Dec 2020 15:05:54 GMT

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.

Re: Filter, Then Sort, Then Select

AntrikshSharma — Wed, 09 Dec 2020 19:46:34 GMT

SearchKnowledge Try this and let me know how it goes: The working file is attached below my signature.

Re: Filter, Then Sort, Then Select

SearchKnowledge — Thu, 10 Dec 2020 08:36:42 GMT

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!

Re: Filter, Then Sort, Then Select

SearchKnowledge — Tue, 15 Dec 2020 08:36:36 GMT

Works like a charm, thank you AntrikshSharma