topic Re: How to find next date using measure in DAX Commands and Tips

How to find next date using measure

Dangar332 — Sat, 30 Sep 2023 10:50:44 GMT

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])

Greg_Deckler — Sat, 30 Sep 2023 13:58:56 GMT

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

Dangar332 — Sat, 30 Sep 2023 14:28:48 GMT

hi, Greg_Deckler thank for reply

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

ThxAlot — Sat, 30 Sep 2023 19:50:20 GMT

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