I want to create a calculated column if the record is created last month

[PowerBITesting]

I want to create a calculated column if the record is created last month 

IsLastMonth =

IF (

YEAR ( Table[date] ) = YEAR ( TODAY () )

&& MONTH ( Table[date] ) = MONTH ( TODAY () ),

"Y",

"N"

)

this is working for current month , what should I change for the last month?

[AlB · Accepted solution]

Hi @PowerBITesting 

IsLastMonth =
IF (
     (
        YEAR ( Table[date] ) = YEAR ( TODAY () )
            && MONTH ( Table[date] )
                = ( MONTH ( TODAY () ) - 1 )
    )
        || (
            YEAR ( Table[date] )
                = ( YEAR ( TODAY () ) - 1 )
                && MONTH ( Table[date] ) = 12
                && ( MONTH ( TODAY () ) = 1 )
        ),
    "Y",
    "N"
)

The second part of the if is just to account for January and December

Please mark the question solved when done and consider giving kudos if posts are helpful.

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

Cheers