Forum Discussion

icdns's avatar
icdns
Post Patron
5 years ago
Solved

SWITCH STATEMENT

Hello,   Could someone help me in deriving result A to result B? Wherein I wanted to fall General Office in Small Business (see result B)  I have 2 columns and I have used a SWITCH STATEMENT but i...
Need Help
  • manikumar34's avatar
    manikumar34
    5 years ago

    icdns , 

     

    Create another calculated column for that. Liek below. 

     

    SEG_MAJ_GRP1 = IF(AND('Table (2)'[SEG_MAJ_GRP] = "HOME",'Table (2)'[SEG_DESC]="GENERAL OFFICE"),SWITCH('Table (2)'[SEG_MAJ_GRP], "HOME","SMALL BUSINESS"),'Table (2)'[SEG_MAJ_GRP])
     
    If you think this is helpful Please Accept as Solution and Leave a like.
     
    Regards, 
    Manikumar
icdns's avatar
icdns
Post Patron
5 years ago

Hi manikumar34 ,

 

Very near!! 😄 But is it possible instead of HOME, GENERAL OFFICE will fall under SMALL BUSINESS? (See font in Red)

 

Thanks alot!!! 🙂 

manikumar34's avatar
manikumar34
Solution Sage
5 years ago

icdns , 

 

Create another calculated column for that. Liek below. 

 

SEG_MAJ_GRP1 = IF(AND('Table (2)'[SEG_MAJ_GRP] = "HOME",'Table (2)'[SEG_DESC]="GENERAL OFFICE"),SWITCH('Table (2)'[SEG_MAJ_GRP], "HOME","SMALL BUSINESS"),'Table (2)'[SEG_MAJ_GRP])
 
If you think this is helpful Please Accept as Solution and Leave a like.
 
Regards, 
Manikumar
  • icdns's avatar
    icdns
    Post Patron
    5 years ago

    it is now working! Thank you! 

    • manikumar34's avatar
      manikumar34
      Solution Sage
      5 years ago

      icdns 

       

      Awesome, you got the Answer you are looking for. 

       

      Your Kudos will be Appreciated. 🙂

       

      Regards, 

      Manikumar