Forum Discussion
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...
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
Hi manikumar34 ,
Sorry i cant paste the file here. but this is just my dataset
Thank you!
Table Name: Table
| SEG_MAJ_GRP | SEG_DESC | CUSTOMER_COUNT |
| CORP | > 500 | 169 |
| CORP | NATIONAL OFFICE | 19 |
| HOME | GENERAL OFFICE | 3832 |
| HOME | LOCAL OFFICE | 169 |
| HOME | HOME OFFICE | 110933 |
| MEKO USE | MEKO USE | 0 |
| N/A | UNDETERMINED | 1 |
| SMALL BUSINESS | < 500 | 1359 |
icdns ,
I'm not clear but if you are looking something like below, Use the provided DAX.
SEG_MAJ_GRP_SWITCH = IF('Table (2)'[SEG_MAJ_GRP] = "CORP", SWITCH('Table (2)'[SEG_DESC], "> 500","> 500","NATIONAL OFFICE","NATIONAL OFFICE"),IF('Table (2)'[SEG_MAJ_GRP] ="SMALL BUSINESS",SWITCH('Table (2)'[SEG_DESC],"GENERAL OFFICE","GENERAL OFFICE","< 500","< 500"),IF('Table (2)'[SEG_MAJ_GRP] = "HOME",SWITCH('Table (2)'[SEG_DESC], "LOCAL OFFICE","LOCAL OFFICE","HOME OFFICE","HOME OFFICE","GENERAL OFFICE"),"N/A")))Regards,ManikumarHi manikumar34 ,
Very near!! 😄 But is it possible instead of HOME, GENERAL OFFICE will fall under SMALL BUSINESS? (See font in Red)
Thanks alot!!! 🙂
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