cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
danjswade
New Member

Extract Data from column based on oldest/newest date

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 AColumn BColumn CColumn D
    
01/01/2112245
01/02/21781262

 

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:

NameOldestCumulativeYoungest
Oranges4510762
1 ACCEPTED SOLUTION
danjswade
New Member

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

View solution in original post

1 REPLY 1
danjswade
New Member

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

View solution in original post

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are You Ready?

Test your skills now with the Cloud Skills Challenge.

Top Solution Authors