Get data with lowest Date

[Anonymous]

I'm trying to find out how to display the lowest value for a specific date to display in a textbox but haven't found anything that is working.

Show ItemId that has the lowest ImportDate. I have been trying out som Set-Analys but can I only use them together with some kind of aggregating function but I only want to show just the value(ItemId) with the lowest ImportDate.

/Frank

[sunny_talwar · Accepted solution]

May be try with FirstSortedValue...

FirstSortedValue(DISTINCT ItemId, ImportDate)

[Anonymous]

Thanks that worked, I'll try it out and see if the result is what I wnt.