Firstsorted value with 2 columns

[brunolelli87]

Dears,

How can I get the date on field PERI, based on the FirstSortedValue of column LOPP? Or,
How can I get the date on field PERI, based on the very first time we have a value of LOPP higher than 0?

Check the picture below:

Thanks,
Bruno Lelli

[Saravanan_Desingh · Accepted solution]

FirstSortedValue(PERI, LOPP)

For the least value of LOPP, the PERI will be pulled.