find value s in Sting and copy add in to the column

[Anonymous]

I would like to Find  the way to populate a column manded on the String I search for 

Example 

ALL MEN

ALL WOMEN

ALL KID

ALL BOY

SEARCH value is MEN ,KID,WOMEN BOY 

DESIRED RESULT 

ALL MEN	MEN
ALL WOMEN	WOMEN
ALL KID	KID
ALL BOY	BOY

[Greg_Deckler · Accepted solution]

Try this:

Column = 
SWITCH(TRUE(),
    CONTAINSSTRING([Column1],"WOMEN"),"WOMEN",
    CONTAINSSTRING([Column1],"MEN"),"MEN",
    CONTAINSSTRING([Column1],"KID"),"KID",
    CONTAINSSTRING([Column1],"BOY"),"BOY",
    BLANK()
)

[v-yuta-msft · Accepted solution]

@Anonymous ,

You can also create a calculate column using DAX below:

Result = RIGHT(Table1[Data], LEN(Table1[Data]) - SEARCH(" ", Table1[Data]))

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Greg_Deckler · Accepted solution]

Try this:

Column = 
SWITCH(TRUE(),
    CONTAINSSTRING([Column1],"WOMEN"),"WOMEN",
    CONTAINSSTRING([Column1],"MEN"),"MEN",
    CONTAINSSTRING([Column1],"KID"),"KID",
    CONTAINSSTRING([Column1],"BOY"),"BOY",
    BLANK()
)

[Anonymous]

Thanks a lot, Greg this really helped