Forum Discussion

Gionedis's avatar
Gionedis
Helper I
3 years ago
Solved

Next Available Date Column

Hello,   i have a table that has non continuous dates, so i created a summarized table to see what are my dates. i want to create a column with the next availbale date, like below:     Tha...
  • lbendlin's avatar
    lbendlin
    3 years ago

    want = 
    var h = [have]

    return calculate(max([have]), all(),[have]<h)

     

     

    Note that performance will be bad with millions of rows but should be ok with your date column.