Extract Data from column based on oldest/newest date

[danjswade]

I have a table which has various info sorted by dates. What I'd like to be able to do is select the data in Column D based on the oldest or newest date in Column A.

Data:

Column A	Column B	Column C	Column D
01/01/21	1	22	45
01/02/21	78	12	62

My current set up on my report is a table which returns the cumulative of Column C over a month. What I'd like to be able to do is next to the cumulative value put the oldest item from Column D and then the newest item Column D, but I can't see a way of doing this. I have a slicer that will adjust the months.

Report:

Name	Oldest	Cumulative	Youngest
Oranges	45	107	62

[danjswade · Accepted solution]

Answered my own questions. FIRSTNONBLANKVALUE and LASTNONBLANKVALUE allows me to put column in for the date and return the colum for the data