The lowest value of the last date by product

[joaopaulo_delco]

Hi Community!

             I have the following issue:

In the visualization, I need to return the lowest value of the last date by product.

My Data:

Desired return:

I'm trying all kinds of combinations of FirstSortedValue function and Aggr but it is not working.

Can someone help me?

[BrunPierre · Accepted solution]

A solution could be this.

Dimensions: Produto and Data

Measure: Min(If(Aggr(NODISTINCT Max(Data), Produto) = Data, Preco))

[joaopaulo_delco]

It works perfectly. Thanks a lot.