Forum Discussion

ArchStanton's avatar
ArchStanton
Icon for Power Participant rankPower Participant
4 years ago
Solved

DAX IF Statement producing errors highlighted in red font

Hi, I have this written this DAX code but its producing the red error bar as per screenshot and I'm not sure why? Also, could this be better written using Variables possibly?     Into Are...
Need Help
  • tamerj1's avatar
    tamerj1
    4 years ago

    ArchStanton 
    Yes sir, if you have got the correct results already then don't worry about it.

tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
4 years ago

Hi ArchStanton 
Please try

Into Area Date =
VAR FunctionalArea = 'Cases - Active'[Functional Area]
VAR SubArea = 'Cases - Active'[Sub Area]
RETURN
    SWITCH (
        TRUE,
        FunctionalArea = "Assessment", 'Cases - Active'[tpo_legacycasecreationdate],
        FunctionalArea = "Casework Support", 'Cases - Active'[new_allocationqueuecaseworksupport],
        FunctionalArea = "Adjudication", 'Cases - Active'[tpo_datepassedtoadjudication],
        FunctionalArea = "Early Resolution", 'Cases - Active'[tpo_dateofertacceptance],
        FunctionalArea = "Assessment"
            && SubArea = "Assessment Post ERT", 'Cases - Active'[tpo_datepassedfromearlyresolution],
        0
    )