Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
Dangar332
Super User
Super User

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

 

 

Dangar332_2-1696071011525.png

 

 

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])
 
1 ACCEPTED SOLUTION
ThxAlot
Super User
Super User

NextDate.pbix

 

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

ThxAlot_0-1696103423491.png



Expertise = List.Accumulate(


        {Days as from Today},


        {Skills and Knowledge},


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


)



View solution in original post

3 REPLIES 3
ThxAlot
Super User
Super User

NextDate.pbix

 

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

ThxAlot_0-1696103423491.png



Expertise = List.Accumulate(


        {Days as from Today},


        {Skills and Knowledge},


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


)



Greg_Deckler
Super User
Super User

@Dangar332 Try:

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...

hi, @Greg_Deckler   thank for reply

 

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

Dangar332_0-1696084080361.pngDangar332_1-1696084100060.png

 

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.

Top Kudoed Authors