Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I am trying to calculate whether a job is a pass or fail based on the SLA using below formula:
Regards,
Fahad
Solved! Go to Solution.
So like this?
Finish Date SLA =
IF(
ISBLANK(F_TASKS[TA_FINISH_DATE]),
IF(TODAY() <= F_TASKS[TA_EST_DATE],"Pass","Fail" ),
IF(F_TASKS[TA_FINISH_DATE] <= F_TASKS[TA_EST_DATE],"Pass","Fail" )
)
Hi @mft_87 ,
Try this :
Finish Date SLA =
IF(
F_TASKS[TA_FINISH_DATE]= BLANK(),
IF(TODAY() <= F_TASKS[TA_EST_DATE],"Pass","Fail" ),
IF(F_TASKS[TA_FINISH_DATE] <= F_TASKS[TA_EST_DATE],"Pass","Fail" )
)
So like this?
Finish Date SLA =
IF(
ISBLANK(F_TASKS[TA_FINISH_DATE]),
IF(TODAY() <= F_TASKS[TA_EST_DATE],"Pass","Fail" ),
IF(F_TASKS[TA_FINISH_DATE] <= F_TASKS[TA_EST_DATE],"Pass","Fail" )
)
worked perfectly and the result is correct as expected, thank you very much.
I need alot of support from this forum to be a power bi champ.
Really appreciate.
Any time @mft_87 !
@mft_87 , Try like
//march release
Finish Date SLA = IF(F_TASKS[TA_FINISH_DATE] <= coalesce(F_TASKS[TA_EST_DATE], today()),"Pass","Fail" )
//Before march release
Finish Date SLA = IF(F_TASKS[TA_FINISH_DATE] <= if(isblank(F_TASKS[TA_EST_DATE]),today(),F_TASKS[TA_EST_DATE]),"Pass","Fai
Thank you very much for your quick reply, but it is giving me the same result.
User | Count |
---|---|
128 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |