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...
  • 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"
        )
    )
)
aduguid's avatar
aduguid
Icon for Memorable Member rankMemorable 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"
        )
    )
)