IF multiple statement for 2 Coulmn

[izzu]

Hi trying to create calculated column with IF statment , stucking to add 3 creatirea please advice

1- IF Target Date is Blank = "InTime"

2- IF  Target Date < Resoved Date = "Breach"

3- IF Resolved Date is Blank and Target Date < current date = "Breach" else "InTime"

BreacTicket = IF(ISBLANK('SRVREQ'[TARGET_DATE]),
"InTime",IF(''SRVREQ'[TARGET_DATE]<'SRVREQ'[RESOLVED_DATE],"Breach",
)

[aduguid · Accepted solution]

try this calculated column

BreacTicket = 
IF(
    ISBLANK('SRVREQ'[TARGET_DATE]), 
    "InTime", 
    IF(
        'SRVREQ'[TARGET_DATE] < 'SRVREQ'[RESOLVED_DATE], 
        "Breach", 
        IF(
            ISBLANK('SRVREQ'[RESOLVED_DATE]) && 'SRVREQ'[TARGET_DATE] < TODAY(), 
            "Breach", 
            "InTime"
        )
    )
)