Solved: How to find next date using measure

Dangar332 · ‎09-30-2023

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 · ‎09-30-2023

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

Expertise = List.Accumulate(

{Days as from Today},

{Skills and Knowledge},

(Current, Everyday) => Current & Day.LeanAndPractise(Everyday)

)

ThxAlot · ‎09-30-2023

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

Expertise = List.Accumulate(

{Days as from Today},

{Skills and Knowledge},

(Current, Everyday) => Current & Day.LeanAndPractise(Everyday)

)

Greg_Deckler · ‎09-30-2023

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

Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...

Dangar332 · ‎09-30-2023

hi, @Greg_Deckler thank for reply

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

How to find next date using measure