how to calculate the lastest value in a time series

[JimB-GA]

I have a simple time series that shows closing stock value by date,  I would like to return the value for the latest date.  In the following sample, the lastest date is 12/12/18 with a value of 271

Date	Value
12/12/18	271
12/11/18	261
12/10/18	260
12/07/18	264
12/06/18	274
12/05/18	264
12/04/18	275
12/03/18	266

Thanks!

Jim B

[JimB-GA]

Thanks!  Worked like a charm the first time.

[Anonymous · Accepted solution]

try:

Last Date =
CALCULATE (
    SUM ( Table1[Value] ),
    LASTNONBLANK ( Table1[Date], SUM ( Table1[Value] ) )
)