Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Get Next Available Date

Hi Guys. 

Stuck on a problem. I have a table of unique JSID and their next date. 

What I am after in the new column is to choose the next available date: 

From the example below, in the "New_NextDate" column, the first record for JSID 123 should show 25 April 2022, and the third record for JSID 123 should show just blank (as there is no next date): 

 

Is there anyway I could replace "MAX" with something that could show next date. 

Need Help
Show and Tell
  • ryan_mayu's avatar
    ryan_mayu
    4 years ago

    Anonymous 

    pls try this

    Column = minx(FILTER('Table','Table'[JSID]=EARLIER('Table'[JSID])&&'Table'[NextDate]>EARLIER('Table'[NextDate])),'Table'[NextDate])

3 Replies