Dax Measure to handle last month for DEC and Today() JAN

[rogerthat]

Hello,

I'm trying to count all records that have been created YTD, up till last month.

Meaning Jan-Oct.

Previous Month = MONTH(TODAY())-1

However, I'm trying to get the logic of when today is actually Janurary, would it be smart enough to get 12?

Or should I write an "if" to handle this stituation? And if so, how would I accomplish this. Kinda stuck here.

TIA~

[AlexisOlson · Accepted solution]

No, it won't give you 12 when TODAY() is in January.

You can handle that case specifically,

Previous Month =
VAR CurrMonth = MONTH ( TODAY () )
RETURN
    IF ( CurrMonth = 1, 12, CurrMonth - 1 )

Or take a slightly different approach:

Previous Month = MONTH ( EOMONTH ( TODAY (), -1 ) )

Or use MOD:

Previous Month = MOD ( MONTH ( TODAY () ) - 2, 12 ) + 1

[rogerthat]

I was able to get it right before your response, I circled back and forth haha but did something simialr to what you suggested!

Thanks!! 😅