Last value based on last date filtered

[andfx]

Hi guys,

For example, I have that data:

FruitPriceDate

Banana	10	11/01/2018
Banana	12	11/01/2018
Banana	11	12/01/2018
Banana	15	12/01/2018

I wish to retrieve the last value based on date

Instead of SUM data for 11/01 I wish to retrieve Price: 12 

And for 12/01 retrieve Price: 15

Thank you.

[Anonymous · Accepted solution]

Assuming that value you want would be the max if more than 1 value was on the same day:

Last Price = 
CALCULATE( 
      MAX(Table2[Price]),
     LASTDATE(Table2[Date] ))