Find most recent transaction - Dataset View

swagner
swagner 🟒

I have a dataset with item receipt dates by branch. I need to find the most recent receiving event for each item by branch. The dataset has about 7M rows, and my thought was to do a dataset view, rank the receipts by branch & item descending on the receipt date. I can't seem to get the calculated column to work.

Any help would be appreciated.

rank() over(partition by Branch, Item order by Receipt Date desc)