Forum Discussion

Shaji's avatar
Shaji
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 ...
Need Help
  • Anonymous's avatar
    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

Shaji's avatar
Shaji
Helper I
6 years ago

I see that the SWITCH true statement only checks single column value. In my question I need to check Two COlumns and then print the results.