Forum Discussion
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...
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 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"
)
,
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?
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.
