Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

DAX Function Next Month

Hey @ all   I want create a Function, which plot the next month. I am currently using the NOW() Funktion. Any Ideas?  
Need Help
  • v-diye-msft's avatar
    v-diye-msft
    6 years ago

    Hi Anonymous 

     

    Kindly let me know if you'd like to get below one:

    Measure 2 = var a = MAX('Table'[Date])
Return
DATE(YEAR(a),MONTH(a)+1,DAY(a))

     

    Or:

    today = TODAY()

Measure 3 = DATE(YEAR([today]),MONTH([today])+1,DAY([today]))

Anonymous's avatar
Anonymous
Not applicable
6 years ago

 

DATEADD(<dates>,<number_of_intervals>,<interval>)

 


So

 

DATEADD(TODAY(),+1,MONTH)