cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
JimB-GA Member
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
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] ) )
)

View solution in original post

2 REPLIES 2
Super User
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] ) )
)

View solution in original post

Highlighted
JimB-GA Member
Member

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

Thanks!  Worked like a charm the first time.

Helpful resources

Announcements
New Topics Started Badges Coming

New Topics Started Badges Coming

We're releasing new versions of the badge that everyone's talking about. ;) Check your inbox for notifications.

MBAS 2020

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

Difinity Conference

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

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

Top Solution Authors
Top Kudoed Authors (Last 30 Days)