How to get one last record of flow of data

[Equalyseur]

Hi everyone,

I can't figure out how to do that:
I have the records of a flow of foretasted price. Means that every 2 minutes I have new price coming for the same point of time in the future.

My goals is to extract of every period of time the latest foretasted point. As the last forecast should be the more accurate.
My time table is :

• time concerned
• Price foretasted
• time of the forecast (time of the run)

I think that power pivot can do it with Filter but i have no clue how.

Someone have an idea how to solve the problem?

Best regards

Stephen