The search Text provided to function 'FIND' could not be found in the given text.

[josephtsmith]

ERROR:

The search Text provided to function 'FIND' could not be found in the given text.

DAX Formula: 

Work Type Category = RIGHT('Work Order'[Work_Type_Service_Coverage__c], LEN('Work Order'[Work_Type_Service_Coverage__c])-FIND(" - ",'Work Order'[Work_Type_Service_Coverage__c]))

Any assistance is appreciated!

[amitchandak]

@josephtsmith , see fine.

Try like one of the two

Work Type Category = RIGHT('Work Order'[Work_Type_Service_Coverage__c], LEN('Work Order'[Work_Type_Service_Coverage__c])-FIND(" - ",'Work Order'[Work_Type_Service_Coverage__c],,0))

Work Type Category = RIGHT('Work Order'[Work_Type_Service_Coverage__c], LEN('Work Order'[Work_Type_Service_Coverage__c])-FIND(" - ",'Work Order'[Work_Type_Service_Coverage__c],,LEN('Work Order'[Work_Type_Service_Coverage__c])))

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

[josephtsmith]

Still searching for resolution; thanks!

[josephtsmith]

Neither option above worked.

Here are some values from the source column (Work_Type_Service_Coverage__c): 

APERIO AT - REPAIR - Service Contract

APERIO AT - UPGRADE - SU Warranty

APERIO AT TURBO - APPLICATION SUPPORT - Application Support

The part that we're trying to get at is the middle between the dashes.

Thanks!

[v-yingjl · Accepted solution]

Hi @josephtsmith ,

Try to modify the formula like this:

Work Type = 
VAR a =
    RIGHT (
        'Work Order'[Work_Type_Service_Coverage__c],
        LEN ( 'Work Order'[Work_Type_Service_Coverage__c] )
            - FIND ( "-", 'Work Order'[Work_Type_Service_Coverage__c] )
    )
RETURN
    LEFT ( a, FIND ( " -", a ) )

Attached a sample file in the below, hopes it could help.

Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.