Forum Discussion

manuelfigueira's avatar
manuelfigueira
Icon for Helper II rankHelper II
6 years ago
Solved

SWITCH condition with ELSE conditional

Hello Everyone!   I have a chain of conditions extracted from a macro and I'm trying to coverted into DAX by using SWITCH (TRUE) function, and somehow is not working as the last condition is kind o...
Need Help
Show and Tell
  • parry2k's avatar
    parry2k
    6 years ago

    manuelfigueira try this, you have everything except last line to catch all

     

    Would appreciate Kudos 🙂 if my solution helped.

     

     

     

    SWITCH(TRUE(),
'348910'[BU_CALC] = "FOOD", "RELEASE",
'348910'[Status_SAP] = "Unmatched Standard" && '348910'[Age] < "91", "HOLD",
'348910'[Status_SAP] = "Unmatched Standard" && '348910'[Age] > "90" && '348910'[Age] < "181", "TIMING",
"RELEASE"
)

     

     

    , 

manuelfigueira's avatar
manuelfigueira
Icon for Helper II rankHelper II
6 years ago

You are a hero parry2k !

 

Quick question for you.- What difference does it makes end SWITCH using the sentence "Blank ())" at the end or not using it? 

parry2k's avatar
parry2k
Icon for Super User rankSuper User
6 years ago

manuelfigueira if you don't put in catch all, it will return BLANK() , assume it is like  null. not sure if this is what you are asking.