blank cell returning incorrect rest in calculated column

[Anonymous]

Hi Experts

i have the following if formula (calculated column)

If(table[timelapsed] <28, "Inscope", if(table[timelapsed] = blank(),"ignore","Completed"). 

the if blank past is returning back "inscope when the end result should be "ignore" as that corressponding cell is empty in the timelasped column

[Pragati11 · Accepted solution]

HI @Anonymous ,

Try modifying your DAX as follows:

If(
   table[timelapsed] <28, "Inscope", 
   if(
      ISBLANK(table[timelapsed]),"ignore","Completed"
     )
   )

Also share some sample data here like what value you are referring to here is BLANK.

Thanks,

Pragati