Case and or Len formula based on column string values

[Anonymous]

Hi Experts

I am looking to add a second column to my table so if the value in

Column A has http://app.powerbi.com/ in the string at the start replace with Power BI and all other string values in column A to 

"Web link" in column B

[ImkeF]

Hi @Anonymous 

In the query editor, add a column with the following formula:

if Text.StartsWith([ColumnA], "http://app.powerbi.com/") then "Web Link" else [ColumnA])

[Greg_Deckler · Accepted solution]

I think maybe:

IF(SEARCH("http://app.powerbi.com/",[Column],,-1) = 1,"Power BI",[Column])

I'm not entirely clear on requirements. 

[Anonymous]

Thanks Greg. Prefect