Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
May be try with FirstSortedValue...
FirstSortedValue(DISTINCT ItemId, ImportDate)
May be try with FirstSortedValue...
FirstSortedValue(DISTINCT ItemId, ImportDate)
Thanks that worked, I'll try it out and see if the result is what I wnt.