Getting Status of My Date if it within this month and 2 previous month

[syaiful_fcpc]

Hi Powerbi Rangers

I need some of ur help .

I have this table 

Plan Stuffing	Result
30-Oct-23	Other Month
17-Nov-23	3 Month
18-Nov-23	3 Month
22-Nov-23	3 Month
07-Des-23	3 Month
08-Des-23	3 Month
09-Des-23	3 Month
07-Jan-24	3 Month
08-Jan-24	3 Month
09-Jan-24	3 Month

i want to create a column similiar with result column, if date within Plan Stuffing is current month and 2 month before this current month then give remark "3 Month", else "Other Month" 

Thanks 
Syaiful

[syaiful_fcpc]

Thanks bro

[DataInsights · Accepted solution]

@syaiful_fcpc,

Try this calculated column:

Result = 
VAR vPlanStuffing = Table1[Plan Stuffing]
VAR vComparisonDate =
    EOMONTH ( TODAY (), -3 )
VAR vResult =
    IF ( vPlanStuffing > vComparisonDate, "3 Month", "Other Month" )
RETURN
    vResult