DAX Function Next Month

[Anonymous]

Hey @ all

I want create a Function, which plot the next month.

I am currently using the NOW() Funktion.

Any Ideas?

[v-diye-msft · Accepted solution]

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]

Perfect.

Works !

[Anonymous]

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

So

DATEADD(TODAY(),+1,MONTH)