Last Order Date

[laura_lacey]

I'm trying to get a table to bring back the last order date for a supplier based on the last PO date. 

I'm using 

=FirstSortedValue(distinct [PO date.autoCalendar.Date],[PO Number])

which brings back the first date. so 01/01/2018 rather than 21/06/2021 

but if I use: 

=FirstSortedValue(distinct -[PO date.autoCalendar.Date],[PO Number])

it brings back a result such as 20/06/1786 

Can you let me know where I'm going wrong here please. 

[Chanty4u]

try this

=FirstSortedValue(distinct [PO date.autoCalendar.Date],-[PO Number])

sample below 

[anat]

can u try like:

=FirstSortedValue(distinct [PO date.autoCalendar.Date],-[PO Number])