Forum Discussion

andfx's avatar
andfx
Frequent Visitor
7 years ago
Solved

Last value based on last date filtered

Hi guys,

 

For example, I have that data:

 

FruitPriceDate

Banana1011/01/2018
Banana1211/01/2018
Banana1112/01/2018
Banana15

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.

Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    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] ))

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    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] ))