Next Available Date Column

[Gionedis]

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

[lbendlin]

Please indicate if you want this in Power Query or DAX.

[Gionedis]

Hello, i need in dax. Thanks

[lbendlin · Accepted solution]

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.