Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

if formula based on string values in text

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. i...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    6 years ago
    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 ")
    )