Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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 |
Solved! Go to Solution.
Answered my own questions. FIRSTNONBLANKVALUE and LASTNONBLANKVALUE allows me to put column in for the date and return the colum for the data
Answered my own questions. FIRSTNONBLANKVALUE and LASTNONBLANKVALUE allows me to put column in for the date and return the colum for the data
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
25 | |
10 | |
8 | |
6 | |
6 |
User | Count |
---|---|
30 | |
11 | |
11 | |
10 | |
6 |