Forum Discussion

izzu's avatar
izzu
Frequent Visitor
2 years ago
Solved

IF multiple statement for 2 Coulmn

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's avatar
    aduguid
    2 years ago

    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"
        )
    )
)

1 Reply

  • aduguid's avatar
    aduguid
    Memorable Member
    2 years ago

    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"
        )
    )
)