cancel
Showing results for
Did you mean:
Highlighted
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
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
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

#### Save the new date (and location)!

Our business applications community is growing—so we needed a different venue, resulting in a new date and location. See you there!

#### Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

#### Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

Top Solution Authors
Top Kudoed Authors (Last 30 Days)