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 ()
)
  • 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