Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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",
)
Solved! Go to 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"
)
)
)
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"
)
)
)
User | Count |
---|---|
21 | |
20 | |
13 | |
10 | |
8 |
User | Count |
---|---|
30 | |
28 | |
13 | |
12 | |
11 |