Forum Discussion

1001's avatar
1001
Resolver II
3 years ago
Solved

Write a SWITCH statement for a range of Numbers

Hi, I have to write a DAX for a calculated column to group a range of numbers from another column. Just wondering how to do this? 1-8 = "short" 9-15="Medium" 16-30="Long".   Many thanks.
Need Help
  • FreemanZ's avatar
    FreemanZ
    3 years ago

    hi 1001 

    this shall also work:

    Column2 =
    SWITCH(
        TRUE(),
        [Column1]<=8,  "Short",
        [Column1]<=15, "Medium",
        [Column1]<=30, "Long",
        "Others"
    )
FreemanZ's avatar
FreemanZ
Super User
3 years ago

hi 1001 

try like:

Column2 =
SWITCH(
    TRUE(),
    [Column1]>=1&&[Column1]<=8,  "Short",
    [Column1]>=9&&[Column1]<=15, "Medium",
    [Column1]>=16&&[Column1]<=30, "Long",
    "Others"
)
  • FreemanZ's avatar
    FreemanZ
    Super User
    3 years ago

    hi 1001 

    this shall also work:

    Column2 =
    SWITCH(
        TRUE(),
        [Column1]<=8,  "Short",
        [Column1]<=15, "Medium",
        [Column1]<=30, "Long",
        "Others"
    )
    • 1001's avatar
      1001
      Resolver II
      3 years ago

      Thanks Freeman, appreciate that.