Forum Discussion

talhaparvaiz's avatar
talhaparvaiz
Icon for Helper I rankHelper I
5 years ago
Solved

New column with values based on another column

Hi,   I have a table that looks something like this   Product  ProdA           ProdBProdA    ProdC ProdDProdB ProdE      I want to add a new column and set the value to GroupA if any of th...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi talhaparvaiz 

     

    Try to add a new column like this:

    Group =
IF (
    ISERROR ( SEARCH ( "ProdA", yourTable[Product] ) ),
    "GroupOther",
    "GroupA"
)
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi talhaparvaiz 

 

Try to add a new column like this:

Group =
IF (
    ISERROR ( SEARCH ( "ProdA", yourTable[Product] ) ),
    "GroupOther",
    "GroupA"
)