Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to 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.
Please indicate if you want this in Power Query or DAX.
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.
User | Count |
---|---|
98 | |
90 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
67 |