Forum Discussion

Munawar1881's avatar
Munawar1881
Helper II
3 years ago

Copy specific word from column to other customize column

Hi,

 

hope all of you are doing well.

 

I have a question if anyone can please answer. I have a product description in one column which contain a word male or female with other details I want to create a column in and want to copy the male, female etc from description column to the new one. how can I do that.

 

please find the example below. it's in Excel but I need to it in Power BI

 

Thank you so much

 

 

Need Help

4 Replies

  • wdx223_Daniel's avatar
    wdx223_Daniel
    Community Champion
    3 years ago

    NewStep=Table.AddColumn(PreviousStepName,"Gender",each List.Skip({"BABY","LADIES","MEN'S"},(x)=>not Text.Contains([Style Name],x,Comparer.OrdinalIgnoreCase){0}? ??"OTHERS")