Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

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
Super User
Super User

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
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.