Forum Discussion
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 ...
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
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
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