How to find next date using measure

[Dangar332]

Greetings,

I have following table. i would like to find next date of current date using measure .

I am calculate it using adding new column to table but i don't know how to calculate using mesure

in above figure i have nextdate which is new added column  .but i want same output using measure

nextdate =

var currentdate = stock[date]

return

 MINX(FILTER(stock,stock[date]>currentdate),stock[date])

[ThxAlot · Accepted solution]

NextDate.pbix

Regardless of calculated column or measure, the formula does the trick

[Greg_Deckler]

@Dangar332 Try:

nextdate =
var currentdate = MAX(stock[date])
return
 MINX(FILTER(stock,stock[date]>currentdate),stock[date])

[Dangar332]

hi, @Greg_Deckler   thank for reply

when i use your code in measure and put in table it give nothing(blank)