cancel
Showing results for
Did you mean:
Member

## how to calculate the lastest value in a time series

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

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User

## Re: how to calculate the lastest value in a time series

try:

```Last Date =
CALCULATE (
SUM ( Table1[Value] ),
LASTNONBLANK ( Table1[Date], SUM ( Table1[Value] ) )
)```
2 REPLIES 2
Highlighted
Super User

## Re: how to calculate the lastest value in a time series

try:

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

## Re: how to calculate the lastest value in a time series

Thanks!  Worked like a charm the first time.

Announcements