I hope there is a quick and easy solution for this. I'm trying to make a calculation based on landed_cost. Problem is that it gets updated quarterly and therefore there can be many landed_Cost values associated with a partnumber. I was wondering if there is a way to find the last entry in the last_update (date dimension)
I tried using lookup and last() but then i get the error saying that these functions must be used with an aggregation.