So I applied the formula below based on your feedback, thank you, I created a slice on the LOCATIONS table and it loads slow with no returned values in the slice:
[Location Key] = INDEX(ORDERBY(SELECT(Locations[Location Key], Full Location=[_THISROW].[Full Location]), [TIME STAMP], TRUE), 1)
I tried creating similar slice formulas on the items table with no luck as well.
On my related table containing the items, called MERCH, I have already setup the most current item location to display as a virtual column called [Current Location] by using this formula:
maxrow(“Locations”, “Time Stamp”, ([Merch ID]=[_THISROW].[Merch ID]))
Essentially, the merch items get scanned multiple times throughout the day at different locations, I need to create a report of the items current locations to update the old database while we transition to Appsheet while maintaining current locations in the legacy database at the end of the day…
Maybe I’m approaching it wrong, thanks again!