Filter to the latest available date

Hi to all the community, been using metabase in my company for some time now and I am totally amazed about how flexible metabase is as a reporting tool.

Lately I am working on a price table for several commodities. Almost each day the prices are downloaded over the internet and stored in this table. For each date I have one price per commodity.

Now what I want to do is to use the latest date price for each commodity in order to run some calculations, but I can't seem to find a way to make the appropriate filter in the date field. I could use the today filter and bring the today's prices, but some times some commodities do not update for a day or two so that would break the calculation.

Thank in advance for anyone who will help..

Hi @zuperkoleoptera
Without completely understanding your structure, I think you're hitting this issue: - upvote by clicking :+1: on the first post
You would have to use SQL currently to have such returns in Metabase.

@flamber yes it seems that this is what I am looking for.
Thanks for the hint, I will keep my eye on the github issue.