Forum Discussion
How 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
in above figure i have nextdate which is new added column .but i want same output using measure
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=C3QY0DWts8wIf this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
5 Replies
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-daxIf not something like that :
next date = SELECTEDVALUE(your table[Date])+1If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
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]returnMINX(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.
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=C3QY0DWts8wIf this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
