Forum Discussion

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?

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

Community Support

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