Forum Discussion
Earl40
Helper I
Helper IHelp with formula to populate new column
Hello, I have formula based on the data below where it searches for a work in the description column then populates a new column based on the search. I want to find a way to add a new step where ...
pls see if this is what you want. you can replace the "XXXXX" to the expected output.
category = SWITCH(TRUE(),SEARCH("Legal",'Table'[Description],1,0)>0,"Legal",SEARCH("XYZ",'Table'[Description],1,0)>0,"XYZ",SEARCH("Compliance",'Table'[Description],1,0)>0,"Compliance",SEARCH("Media",'Table'[Description],1,0)>0,"Media",'Table'[Assigned by] in {"Mike","George"}&&'Table'[Source]="Auto"&&'Table'[Type]="Case","XXXXX")
ryan_mayu
Super User
Super Userpls see if this is what you want. you can replace the "XXXXX" to the expected output.
category = SWITCH(TRUE(),
SEARCH("Legal",'Table'[Description],1,0)>0,"Legal",
SEARCH("XYZ",'Table'[Description],1,0)>0,"XYZ",
SEARCH("Compliance",'Table'[Description],1,0)>0,"Compliance",
SEARCH("Media",'Table'[Description],1,0)>0,"Media",
'Table'[Assigned by] in {"Mike","George"}&&'Table'[Source]="Auto"&&'Table'[Type]="Case","XXXXX")