How to get last month number as 12 if current month number is 1 which is january this year

[Ramendra]

Hi All,
Can some one help with below.
How to get last month number as 12 for last year if current month number is 1 which is january this year?

[filipeoliveira · Accepted solution]

You can try something like this:

MeasureName =

VAR Current_Month = MONTH(SELECTEDVALUE('Table_Name'[Date]))

RETURN

IF(Current_Month=1,12,Current_Month-1)