IF multiple statement for 2 Coulmn

izzu — Tue, 09 Jul 2024 13:30:56 GMT

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

Re: IF multiple statement for 2 Coulmn

aduguid — Wed, 10 Jul 2024 00:57:40 GMT

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

topic Re: IF multiple statement for 2 Coulmn in DAX Commands and Tips

IF multiple statement for 2 Coulmn

Re: IF multiple statement for 2 Coulmn