Forum Discussion
Gionedis
3 years agoHelper I
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...
- 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.
lbendlin
3 years agoSuper User
Please indicate if you want this in Power Query or DAX.