DAX Replace with wildcards

[Anonymous]

Customer	Price
Costco USA	754
Walmart MX	365
Kenny's USA	956
Freddy's	457

From the table above I need to replace the whole cell value for only those that contain the word "USA" to "Offboarded" so I can end up with a table like this

Customer	Price
Offboarded	754
Walmart MX	365
Offboarded	956
Freddy's	457

I have looked into DAX's "Replace" and "substitute" but cannot make it work for this particular scenario where I believe the usage of *wildcards* may be required.

Any suggestions are truly appreciated.

[amitchandak · Accepted solution]

@Anonymous , Try a new column like

if(search("USA",[Customer],,0) >0, "Offboarded",[Customer])