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

[Ritaf1983 · Accepted solution]

Ok @Dangar332 
You can use the offset function:

next date offset =

CALCULATE(min('yortable'[Date]),OFFSET(+1,ALLSELECTED('yourtable'[Date]),ORDERBY('yourtable'[Date],ASC)))

more information about this function here :
https://www.youtube.com/watch?v=C3QY0DWts8w

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.

[Dangar332]

@Ritaf1983 ,

Thank you for guidance

[Ritaf1983]

Glad to help 🙂

[Ritaf1983]

Hi @Dangar332 
There are many methods to achieve this goal.

If you have a calendar table, you can use the generic Dax function nextday:
https://learn.microsoft.com/en-us/dax/nextday-function-dax

If not something like that :

next date = SELECTEDVALUE(your table[Date])+1

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.

[Dangar332]

hi, @Ritaf1983  thanks for reply

i have different condition

let's consider below table

date

2/17/2023

2/25/2023

7/18/2023

8/9/2023

9/27/2023

let current date is 2/17/2023 then next date is 2/25/2023

let current date is 7/18/2023 then next date is 8/9/2023

let current date is 8/8/2023 then next date is 9/27/2023

these  same result done by adding new column but i want in new measure instead of new column

nextdate =

var currentdate = stock[date]

return

 MINX(FILTER(stock,stock[date]>currentdate),stock[date])   ----- these give me result as i want but i have to calculate in column but  i want in measure.