Ignore Empty | Blank Cells in Uploaded Column

[Anonymous]

Hi Expert

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..

[amitchandak]

@Anonymous ,

Period =
VAR p=find("P",'Table'[Uploaded],1)
return if(not(isblank('Table'[Uploaded])) , MID('Table'[Uploaded],p+1,100)*1 , blank())

[Anonymous]

Hi amit - Smaple data is here https://community.powerbi.com/t5/Desktop/Sum-of-previous-Periods-Grouped/m-p/2225491#M812064

the above formula is giving me an error "the search text provided to function "Find" could not be found in the given text"

[v-yiruan-msft · Accepted solution]

Hi @Anonymous ,

You can update your calculated column [Period] as below:

Period = 
VAR p =
     IFERROR ( FIND ( "P", 'Table'[Uploaded], 1 ), 0 ) 
RETURN
    IF ( p = 0, BLANK (), MID ( 'Table'[Uploaded], p + 1, 100 ) * 1 )

Best Regards