Forum Discussion

newkingdom's avatar
newkingdom
Frequent Visitor
7 years ago
Solved

Next available day

Hi I have a patienid and dates. I want to choose the next earliest date.                          patientid   date     patietid nextdate       1   8/20/2019     1 ...
Need Help
  • AlB's avatar
    AlB
    7 years ago

    Hi newkingdom 

    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] > TODAY () )
AlB's avatar
AlB
Community Champion
7 years ago

Hi newkingdom 

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] > TODAY () )