HI, I’m using the deliveries and delivery details model and got most of my app to work quiet well. I am loaning unique items from stock and need would like to look up a customer to see what stock they have. Also to look up a stock item and see where it is. I have sorted the first of these problems with this formula in customers table:
This works ok but relies on the location being correct from this formula in stock table:
=INDEX(SORT(SELECT(Delivery Details[CustomerRef],[Stock ID] = [_THISROW]),TRUE),1)
Before this formula is sorted it lists the deliveries of a stock item in the order they are entered. The last entry in the list is where the stock item was delivered last i.e. where it is now which is what I need know. To reference the last entry in a list I need to sort it in reverse order and INDEX value 1. However when I sort the list it puts it into alphabetical order, not entry (or ideally date delivered) order, so it doesn’t work.
Am I going about this the wrong way? Any help would be most welcome.