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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

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
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.