Next available day

Question

Hi I have a patienid and dates. I want to choose the next earliest date.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;patientid&nbsp;date&nbsp;&nbsp;patietidnextdate&nbsp;&nbsp;&nbsp;1&nbsp;8/20/2019&nbsp;&nbsp;19/21/2019&nbsp;&nbsp;&nbsp;1&nbsp;9/21/2019&nbsp;&nbsp;29/26/2019&nbsp;&nbsp;&nbsp;1&nbsp;10/22/2019&nbsp;&nbsp;39/28/2019&nbsp;&nbsp;&nbsp;2&nbsp;8/23/2019&nbsp;&nbsp;48/30/2019&nbsp;&nbsp;&nbsp;2&nbsp;8/24/2019&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;2&nbsp;10/25/2019&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;2&nbsp;9/26/2019&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;3&nbsp;8/27/2019&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;3&nbsp;9/28/2019&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;3&nbsp;9/29/2019&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;4&nbsp;8/30/2019&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;so in essence, find the earliest date which is greater than today

alb · Accepted Answer

Hi&nbsp;newkingdom&nbsp;
1. Place Table1[patientid] in the rows of a table visual
2. Create this measure and place it in the visual
NextDate =
CALCULATE ( MIN ( Table1[Date] ), Table1[Date] &gt; TODAY () )

Forum Discussion

Next available day

1 Reply

Related content

Days available in month

ParaTimeLine not available

first day of the month available

Data Days | Data Days Your Way

Day to Day average


patientid	date	patietid	nextdate
1	8/20/2019	1	9/21/2019
1	9/21/2019	2	9/26/2019
1	10/22/2019	3	9/28/2019
2	8/23/2019	4	8/30/2019
2	8/24/2019
2	10/25/2019
2	9/26/2019
3	8/27/2019
3	9/28/2019
3	9/29/2019
4	8/30/2019