cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
1001
Resolver II
Resolver II

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.

1 ACCEPTED SOLUTION

hi @1001 

this shall also work:

Column2 =
SWITCH(
    TRUE(),
    [Column1]<=8,  "Short",
    [Column1]<=15, "Medium",
    [Column1]<=30, "Long",
    "Others"
)

View solution in original post

3 REPLIES 3
FreemanZ
Community Champion
Community Champion

hi @1001 

try like:

Column2 =
SWITCH(
    TRUE(),
    [Column1]>=1&&[Column1]<=8,  "Short",
    [Column1]>=9&&[Column1]<=15, "Medium",
    [Column1]>=16&&[Column1]<=30, "Long",
    "Others"
)

hi @1001 

this shall also work:

Column2 =
SWITCH(
    TRUE(),
    [Column1]<=8,  "Short",
    [Column1]<=15, "Medium",
    [Column1]<=30, "Long",
    "Others"
)

Thanks Freeman, appreciate that. 

Helpful resources

Announcements
PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Top Solution Authors