Forum Discussion

ArchStanton's avatar
ArchStanton
Icon for Power Participant rankPower Participant
10 months ago
Solved

IF Statement or Switch

I've read that Switch statements are more efficient and less costly than IF statements so I'm trying to convert this code to Switch but I'm not sure how I can avoid the IF at the beginning? ...
Need Help
Show and Tell
  • mh2587's avatar
    mh2587
    10 months ago
    Days to Validation Bins = //Try this
VAR _Created = 'Cases'[Created On]
VAR _State   = 'Cases'[statecode]
VAR _Days    = 'Cases'[Days to Validation]
RETURN
SWITCH(
    TRUE(),
    AND(_Created < DATE(2020,4,1), OR(_State = "Resolved", _State = "2")), BLANK(),
    ISBLANK(_Days), BLANK(),
    _Days <= 30, "0-1 Mth",
    _Days <= 60, "1-2 Mths",
    _Days <= 90, "2-3 Mths",
    "Older"
)
mh2587's avatar
mh2587
Icon for Super User rankSuper User
10 months ago
Days to Validation Bins = //Try this
VAR _Created = 'Cases'[Created On]
VAR _State   = 'Cases'[statecode]
VAR _Days    = 'Cases'[Days to Validation]
RETURN
SWITCH(
    TRUE(),
    AND(_Created < DATE(2020,4,1), OR(_State = "Resolved", _State = "2")), BLANK(),
    ISBLANK(_Days), BLANK(),
    _Days <= 30, "0-1 Mth",
    _Days <= 60, "1-2 Mths",
    _Days <= 90, "2-3 Mths",
    "Older"
)