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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
shaik1
Frequent Visitor

I need to create Days range like <30 and 30-60 and 60-90 and 90-120 and >120

Hi Team,

I need to do days range like <30 and 30-60 and 60-90 and 90-120 and >120.I have attached screenshot. Please help on this.

 

shaik1_0-1670578073880.png

 

 

2 REPLIES 2
Mahesh0016
Super User
Super User

Mahesh0016_0-1670584308369.png

DD = SWITCH(TRUE(),[Day_Range]<=30,"< 30 days",
[Day_Range]>30 && [Day_Range]<=60,"30 - 60 days",
[Day_Range]>60 && [Day_Range]<=90,"60 - 90 days",
[Day_Range]>90 && [Day_Range]<=120,"90 - 120 days",
"120 days")
Hello@shaik1 @amitchandak ,
I hope it is helpful for you.
 
Mahesh Patel,
9137376364
amitchandak
Super User
Super User

@shaik1 , If you have a column, then new column 

 

 

example 

 

Switch(True(),

[Days] < 30, "  < 30 Days",

[Days] < 60, " 30 -60 Days",

[Days] < 90, " 60- 90 Days",

"> 90"

)

 

Modify as per need

 

 

If days is a measure, then you need 

 

Dynamic Segmentation Bucketing Binning
https://community.powerbi.com/t5/Quick-Measures-Gallery/Dynamic-Segmentation-Bucketing-Binning/m-p/1...


Dynamic Segmentation, Bucketing or Binning: https://youtu.be/CuczXPj0N-k

 

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

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