How to fetch id with maximum date?

[fallenangel6]

Hi All,

I have below data with me. 

clsid	partyid	accountid	AccountOpeningDate
12111111	123	1000	23-05-2016
12111111	123	5000	24-03-2017
12111111	123	3000	12-03-2019
12111111	123	3999	25-09-2016

i want the below output from this. Please help. i want the record with account ID which is the latest.

clsid	partyid	accountid	AccountOpeningDate
12111111	123	3000	12-03-2019

[jonathandienst · Accepted solution]

Something like:

FirstSortedValue(clsid, -AccountOpeningDate)

[pradosh_thakur]

Dimension1 - clsid

Dimension2 - partyid

Measure1 - FirstSortedValue(accountid,-AccountOpeningDate)

Measure2 - FirstSortedValue(AccountOpeningDate,-AccountOpeningDate)

[fallenangel6]

Hi,

what if i have this data

clsid	partyid	accountStatus	accountid	AccountOpeningDate
12111111	123	Active	1000	23-05-2016
12111111	123	Active	5000	24-03-2017
12111111	123	Closed	3000	12-03-2019
12111111	123	Closed	3999	25-09-2016

and my desired output is as below,

clsid	partyid	accountStatus	accountid	AccountOpeningDate
12111111	123	Active	3000	12-03-2019