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

[shaik1]

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.

[Mahesh0016]

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]

@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