Forum Discussion
Dangar332
Resident Rockstar
Resident RockstarHow to find next date using measure
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 ...
Greg_Deckler
Community Champion
Community ChampionDangar332 Try:
nextdate =
var currentdate = MAX(stock[date])
return
MINX(FILTER(stock,stock[date]>currentdate),stock[date])
Dangar332Resident Rockstar
Resident Rockstarhi, Greg_Deckler thank for reply
when i use your code in measure and put in table it give nothing(blank)