Forum Discussion

Helper I

6 years ago

Solved

Need Help

Hi All, I have table with muliple columns inlcusing the below two: Event Type AAA Cust123 BBB Cust123 AAA CP BBB CP AAA B2B BBB B2B now based on the above two ...

Anonymous
6 years ago
Hi Shaji ,

You can use SWITCH also

SWITCH(
TRUE(),

Table'[Event] = "AAA" && Table[Type] = "Cust123", "Customer",
Table'[Event] = "BBB" && Table[Type] = "Cust123", " Other Customer"

)

Regards
HN

Anonymous

Not applicable

6 years ago

Hi Shaji ,

Can you share the logic of the 3rd Column.

How do you identify if he is a customer, partner or others.

Regards,

HN

Shaji
Helper I
6 years ago
So basicall we have two type of Event. IN the example it is AAA and BBB. And for each event there is a set of "Type" which will be common to both AAA and BBB.

So now if Event = AAA and Type=Cust123 i should get the NewType = Customer
similarly if Event = BBB and Type=Cust123 i should get the NewType = Other

So based on Column Event and Type I should get the result in NewType.

Hope you can get some idea on what I am looking for
- Anonymous
  Not applicable
  6 years ago
  Hi Shaji ,
  
  Not sure how will you replace Cust123 with Customer, etc... How many combinations like this do you have.
  
  You can try this.
  
  Column = IF('Table'[Event] = "BBB", CONCATENATE("Other " , 'Table'[Type]),'Table'[Type])
  
  Regards,
  Harsh Nathani
  - Anonymous
    Not applicable
    6 years ago
    Hi Shaji ,
    
    You can use SWITCH also
    
    SWITCH(
    TRUE(),
    
    Table'[Event] = "AAA" && Table[Type] = "Cust123", "Customer",
    Table'[Event] = "BBB" && Table[Type] = "Cust123", " Other Customer"
    
    )
    
    Regards
    HN