FIRSTSORTEDVALUE

[BI_Dev]

Hi - How to use first sorted value on date format which has time also ? Ex. Below

Amount	Date
1000	07/26/2021 1:35:00 PM
2000	07/26/2021 1:33:00 PM

Result would be $1000.

Thank you.

[rwunderlich]

Internally, a Timestamp is just a number with a fraction.  So the value can be used for ordering just like an integer. 

FirstSortedValue(Amount, -Date)

-Rob

[BI_Dev]

I tried that but did not work. So converted date to numeric value and did firstsort on that. Thank you much.