Get records with highest dates

[#1]

Hi,

I have situation where I must extract records with highest starting date if they are more than one SifDat values..

Was tried with FirstSortedValue, but I always get blank records..

Any idea and thanks in advance,

Igor

[#2]

could u pls share some sample data

[#3]

sample data is in attached qwv, Thx

[sasikanth · Accepted solution]

Try below expression in chart

=FirstSortedValue(  [Starting Date],- aggr( max([Starting Date]),SifDat,SifraCen))

[#5]

Thx a lot ..