The value is null but the formula is showing pass, based on my condition, need help

[Anonymous]

I am trying to calculate whether a job is a pass or fail based on the SLA using below formula:

Finish Date SLA = IF(F_TASKS[TA_FINISH_DATE] <= F_TASKS[TA_EST_DATE],"Pass","Fail" )

but for some jobs the TA_FINISH_DATE (Date Closed) has not been updated yet, so due to null value the condition still says it is a pass as per the below image: what I need is, if there is a null value it should either take todays date and do the calculation to pass/fail. I am new to power bi and trying to learn stuff, i would highly appreciate any support.

Regards,

Fahad

[v-kelly-msft]

Hi @Anonymous ，

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

 
Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[Greg_Deckler · Accepted 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" )
  )

[Anonymous]

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.

[Greg_Deckler]

Any time @Anonymous !

[amitchandak]

@Anonymous , 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

[Anonymous]

Thank you very much for your quick reply, but it is giving me the same result.