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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
daydream1989
Helper I
Helper I

date range 0 - 90 days, 90 - 180 days, 180 - 360 days

Hi, I have a set of data which i have a list of number of days for aging and i want to add a column that calculate the range by '0-90 days, 90-180 days, 181 - 360 days. Example, anything fall in 90 days, then it will show under the range 0 - 90 days in the range column. How can i create this column in power BI?

 

daydream1989_0-1679040404930.png

 

2 ACCEPTED SOLUTIONS
KeyurPatel14
Responsive Resident
Responsive Resident

HI @daydream1989 ,
You can add a calculated column in PowerBI using below formula:
Resultcolumn = 
SWITCH(

Table1[Open Workflow Aging],

Table1[Open Workflow Aging] >0 && Table1[Open Workflow Aging] <=90,"0-90 days",

Table1[Open Workflow Aging] >90 && Table1[Open Workflow Aging] <=180,"90-180 days",

Table1[Open Workflow Aging] >180 && Table1[Open Workflow Aging] <=360,"180-360 days"
)

I hope this will solve your problem and if you have any queries then please let me know.
And if this helps you then please give it a kudos and accept it as a solution.
Thank you.

 

View solution in original post

Try this,

Resultcolumn = 
SWITCH(

TRUE(),

Table1[Open Workflow Aging] >0 && Table1[Open Workflow Aging] <=90,"0-90 days",

Table1[Open Workflow Aging] >90 && Table1[Open Workflow Aging] <=180,"90-180 days",

Table1[Open Workflow Aging] >180 && Table1[Open Workflow Aging] <=360,"180-360 days"
)

I have just changed first argument to TRUE().
If this solves your problem then please give it a kudos and accept it as a solution.
Thank you.

View solution in original post

5 REPLIES 5
KeyurPatel14
Responsive Resident
Responsive Resident

HI @daydream1989 ,
You can add a calculated column in PowerBI using below formula:
Resultcolumn = 
SWITCH(

Table1[Open Workflow Aging],

Table1[Open Workflow Aging] >0 && Table1[Open Workflow Aging] <=90,"0-90 days",

Table1[Open Workflow Aging] >90 && Table1[Open Workflow Aging] <=180,"90-180 days",

Table1[Open Workflow Aging] >180 && Table1[Open Workflow Aging] <=360,"180-360 days"
)

I hope this will solve your problem and if you have any queries then please let me know.
And if this helps you then please give it a kudos and accept it as a solution.
Thank you.

 

Hi, but i get the below error. How can i fix it?

 

daydream1989_0-1679043620336.png

 

Try this,

Resultcolumn = 
SWITCH(

TRUE(),

Table1[Open Workflow Aging] >0 && Table1[Open Workflow Aging] <=90,"0-90 days",

Table1[Open Workflow Aging] >90 && Table1[Open Workflow Aging] <=180,"90-180 days",

Table1[Open Workflow Aging] >180 && Table1[Open Workflow Aging] <=360,"180-360 days"
)

I have just changed first argument to TRUE().
If this solves your problem then please give it a kudos and accept it as a solution.
Thank you.

Really thanks a lot!!!

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

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