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:

 

 

Thanks

Need Help
  • 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.

3 Replies

      • lbendlin's avatar
        lbendlin
        Super User
        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.