Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Tricky IF DAX Formula

Hi Experts   I want to do the following as a either a if or Switch in a calculated column...   If (RTT[Actual_Weeks_Waiting] < 18, "Under 18", If (RTT[Actual_Weeks_Waiting] >=18, "18+", If (RT...
Need Help
  • DataInsights's avatar
    DataInsights
    3 years ago

    Anonymous,

     

    Try this calculated column:

     

    CalculatedColumn =
SWITCH (
    TRUE,
    RTT[Actual_Weeks_Waiting] >= 78, "78+",
    RTT[Actual_Weeks_Waiting] >= 72, "72+",
    RTT[Actual_Weeks_Waiting] >= 52, "52+",
    RTT[Actual_Weeks_Waiting] >= 18, "18+",
    RTT[Actual_Weeks_Waiting] < 18, "Under 18",
    BLANK ()
)
DataInsights's avatar
DataInsights
Super User
3 years ago

Anonymous,

 

Try this calculated column:

 

CalculatedColumn =
SWITCH (
    TRUE,
    RTT[Actual_Weeks_Waiting] >= 78, "78+",
    RTT[Actual_Weeks_Waiting] >= 72, "72+",
    RTT[Actual_Weeks_Waiting] >= 52, "52+",
    RTT[Actual_Weeks_Waiting] >= 18, "18+",
    RTT[Actual_Weeks_Waiting] < 18, "Under 18",
    BLANK ()
)
  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Excellent sir worked.......

    • DataInsights's avatar
      DataInsights
      Super User
      3 years ago

      Anonymous,

       

      Glad to hear it worked. By the way, you can remove the BLANK() argument since it will return BLANK if none of the conditions are met.

    • DataInsights's avatar
      DataInsights
      Super User
      3 years ago

      Anonymous,

       

      I looked at your other post and noticed a missing close parenthesis at the end.

      • Anonymous's avatar
        Anonymous
        Not applicable
        3 years ago

        Hi - even with that corrected its still not returning back the correct result