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?

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

Not applicable

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

DATEADD(TODAY(),+1,MONTH)