cancel
Showing results for
Did you mean:

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

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

hi @1001

this shall also work:

Column2 =
SWITCH(
TRUE(),
[Column1]<=8,  "Short",
[Column1]<=15, "Medium",
[Column1]<=30, "Long",
"Others"
)
3 REPLIES 3
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"
)
Super User

hi @1001

this shall also work:

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

Thanks Freeman, appreciate that.

Announcements

#### Fabric certifications survey

Certification feedback opportunity for the community.

#### Power BI Monthly Update - April 2024

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

#### Fabric Community Update - April 2024

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

Top Solution Authors
Top Kudoed Authors