Forum Discussion

Mk60's avatar
Mk60
Resolver I
2 years ago
Solved

How to replace nested IF calculation for New Column with using switch

This nested if calculation DOES work fine, but I have hard time replacing this using SWITC function? I amm affraid that if I have much longer nested calc it might be safer to use switch instead. Can ...
Need Help
  • MattAllington's avatar
    MattAllington
    2 years ago

    I believe this would be better done in Power Query using conditional columns. To answer your question, you could use switch/true

     

    =SWITCH(TRUE(),

    Query1[PRODUCT]="20","Prod1",

    Query1[PRODUCT]="CC-20b","Prod2",

    etc

     

     

    also, use daxformatter.com to make it easier to read. 

akoren2's avatar
akoren2
Advocate I
2 years ago

Product = SWITCH(

                         TRUE(),
                          Query1[PRODUCT] IN { "20"} , Prod1,
                          ....
                          Query1[PRODUCT] IN { "31","43","50", etc} , Prod4,
                          ....
                          Else statement if needed)