How to find previous maximum date

[shrini]

For example:-

Policy No   Date
1   10/12/2013
1   1/8/2012
1   23/06/2013

For policy no1 result would be 23/06/2013. I dont have any transaction number for each date to pick. Please let me know, if anybody has solution.


Thanks,
Srini.

[MDXpressor]

A couple of ways to manage this shrini.

but with some brute force:

[minDate]: 

Code Select Expand

minimum([Namespace].[Query Subject].[Date] for [Policy No])

Then, filter for:

Code Select Expand

[Namespace].[Query Subject].[Date]=[minDate]

This will leave you with only the 1st record. 


If you want all records to show up, allow a rank on dates per Policy No to become your ID's:

Code Select Expand

rank([Date] for [Policy No])

[shrini]

Thanks MDX, I got it.