Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
try this
=FirstSortedValue(distinct [PO date.autoCalendar.Date],-[PO Number])
sample below
can u try like:
=FirstSortedValue(distinct [PO date.autoCalendar.Date],-[PO Number])