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
Go to Solution.
Last Date =
SUM ( Table1[Value] ),
LASTNONBLANK ( Table1[Date], SUM ( Table1[Value] ) )
View solution in original post
Thanks! Worked like a charm the first time.
Kudos to you if you earned one of these! Check your inbox for a notification.
Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.
Find out where you can attend!