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_NextD...
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])

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Thanks ryan_mayu it works perfectly. 

Mind explaining how the formula is working?