if formula based on string values in text

[Anonymous]

Hi Experts

I have a column in Table that has string values thats start with either complaints and sales as follows:

1. complaints_text_ and

2. sales.csv 

Formula to go into new column

1. if the string start complaints_ replace the value as Complaints

2. if the strinf starts sales.csv replace the value as Sales

and all other strings in column A remain as is.

[Greg_Deckler · Accepted solution]

So perhaps:
Column1 =
SWITCH(TRUE()
"complaints_" IN { 'Table'[Column] }, SUBSTITUTE('Table'[Column],"complaints_","Complaints "),
"sales.csv" IN { 'Table'[Column] }, SUBSTITUTE('Table'[Column],"sales.csv","Sales ")
)

[Anonymous]

thanks Greg

[Greg_Deckler]

Sure!

[amitchandak]

Refer : https://docs.microsoft.com/en-us/dax/replace-function-dax

https://docs.microsoft.com/en-us/powerquery-m/text-replace