Replace blank/Empty cell with P0 in result column

[Anonymous]

Hi Experts

Need to amend the following calculated column measure to ignore where we have a empty cell in Uploaded column in the table

Period =

VAR p=find("P",'Table'[Uploaded],1)

return MID('Table'[Uploaded],p+1,100)*1

Currently this is returning an error when the first rows are blank..and replace where we have blank in uploaded column with P0 in new column.

[SwathiKundar]

Try this

Period =
VAR p=find("P",'Table'[Uploaded],1)
return If('Table'[Uploaded]<>blank(), MID('Table'[Uploaded],p+1,100)*1))

[rsbin · Accepted solution]

@Anonymous 

One way to handle this is to use an IF statement to check for blank cells.  Try something like:

Period =
VAR p=IF ( ISBLANK[Uploaded]=TRUE(), 0, find("P",'Table'[Uploaded],1))
return 
IF(ISBLANK[Uploaded]=TRUE(),"P0", MID('Table'[Uploaded],p+1,100)*1

I am not perfect at writing syntax on the fly, so some adjustments might be necessary.  But I hope this points you in the right direction.

Good Luck and Regards,