Calculation of the last price

[Syndicate_Admin]

Very good, I have the following doubt to see if they can help me

I have a table such as the following:

ID Item Date Price

1 A 01/02/22 20

2 A 03/04/22 30

3 A 03/04/22 40

4 A 05/06/23 -50

I need to know the last price to a given date and if there are two prices for the same date that takes the one with the highest IDLinea.

The list would be like this

January 0

February 20

March 20

April 40

May 40

June -55

July -55

August -55

Thanks a lot!!!!

[Jihwan_Kim · Accepted solution]

Hi,

I am not sure if I understood your question correctly, but please check the below picture and the attached pbix file.

[Syndicate_Admin]

Well, in order not to be clear about what I asked for, you have been right in full. I have moved it to the model and it works perfectly for me.

I will perform more checks and especially study the code.

Thank you so much.