Get month number of previous month

[banthorpe]

OK - I need to get the number of the previous month as an integer.

I currently get teh current month using:

MONTH(NOW())

but I cannot simply subtract 1 as if the current month was January (ie. 1) then the previous month would come out as 0 instead of 12 (december).

Any thoughts?

[banthorpe · Accepted solution]

actuaylly just came up with this - is this OK?

test = IF(Month(NOW())>1,MONTH(NOW())-1,12)

[banthorpe · Accepted solution]

actuaylly just came up with this - is this OK?

test = IF(Month(NOW())>1,MONTH(NOW())-1,12)

[v-chuncz-msft · Accepted solution]

@banthorpe,

You may use DAX below as well.

m =
MONTH ( TODAY () - DAY ( TODAY () ) )