Avoid empy cells with FirstSorted

[Micki]

Hi folks, 

I have the following table 

FirstSortedValue(DISTINCT Iter, -EndDate, 2) 

An result is null() (because 2 from the end is empty )could you help me to avoid null cell in firstsortedvalue or maybe is there another way to do ? 

[sunny_talwar · Accepted solution]

@Micki try this

FirstSortedValue({<Iter *= {"*"}>} DISTINCT Iter, -EndDate, 2) 

[Micki]

@sunny_talwar  Thank you so much