cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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?

2 ACCEPTED SOLUTIONS
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.

Responsive Resident

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.

5 REPLIES 5
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.

Helper I

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

Responsive Resident

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.

Helper I

Really thanks a lot!!!

Super User

Regards,

Ritesh