cancel
Showing results for
Did you mean:
Regular Visitor

## How to create time slots in Power BI data set ?

Hi All,

My data looks like this in excel:

Networkdays                 CYCLE TIMES
3                                    0-3 days
1                                    0-3 days
51                                 31+ days
4                                   4-7 days
4                                  4-7 days
14                                8-14 days

For "Cycle Time" there is a formula in this column that is
=IF(A2<=3,"0-3 days",IF(A2<=7,"4-7 days",IF(A2<=14,"8-14 days",IF(A2<=30,"15-30 days","31+ days"))))

I want to do same in Power BI Desktop.
Please assist how we can build a column like Cycle Time in Power BI dataset.

Thank you.

3 ACCEPTED SOLUTIONS

Accepted Solutions
Moderator

## Re: How to create time slots in Power BI data set ?

Hi @sanjeev803

Right click your table in Power BI Desktop, select “New column”, paste the following formula. Then create a table visual, for more details, see the example in the screenshots below.

CYCLE TIMES = IF(Table[Networkdays]<=3, "0-3 days",IF(Table[Networkdays]<=7,"4-7 days",IF(Table[Networkdays]<=14,"8-14 days",IF(Table[Networkdays]<=30, "15-30 days","31+ days"))))

Thanks,
Lydia Zhang

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Regular Visitor

## Re: How to create time slots in Power BI data set ?

... and if you want to avoid all those nested IF statements you can use the SWITCH statement:

SWITCH(TRUE(),

NetworkDays <= 3, "0-3 days",

NetworkDays <=10, "3-10 days",

"10+ days")

Cheers,

Christian

Regular Visitor

## Re: How to create time slots in Power BI data set ?

Thank you. Its working perfectly fine. 🙂

4 REPLIES 4
Regular Visitor

## How to Create Time slot in power BI Data Set ?

Hi All,

My data looks like this in excel:

Networkdays        CYCLE TIMES
3                           0-3 days
1                           0-3 days
51                        31+ days
4                          4-7 days
4                         4-7 days
14                       8-14 days

For "Cycle Time" there is a formula in this column that is
=IF(A2<=3,"0-3 days",IF(A2<=7,"4-7 days",IF(A2<=14,"8-14 days",IF(A2<=30,"15-30 days","31+ days"))))

I want to do same in Power BI Desktop.
Please assist how we can build a column like Cycle Time in Power BI dataset.

Thank you.

Moderator

## Re: How to create time slots in Power BI data set ?

Hi @sanjeev803

Right click your table in Power BI Desktop, select “New column”, paste the following formula. Then create a table visual, for more details, see the example in the screenshots below.

CYCLE TIMES = IF(Table[Networkdays]<=3, "0-3 days",IF(Table[Networkdays]<=7,"4-7 days",IF(Table[Networkdays]<=14,"8-14 days",IF(Table[Networkdays]<=30, "15-30 days","31+ days"))))

Thanks,
Lydia Zhang

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Regular Visitor

## Re: How to create time slots in Power BI data set ?

... and if you want to avoid all those nested IF statements you can use the SWITCH statement:

SWITCH(TRUE(),

NetworkDays <= 3, "0-3 days",

NetworkDays <=10, "3-10 days",

"10+ days")

Cheers,

Christian

Regular Visitor

## Re: How to create time slots in Power BI data set ?

Thank you. Its working perfectly fine. 🙂

Announcements

Kudos to you if you earned one of these! Check your inbox for a notification.

#### Microsoft Implementation for Communities Wins Award

Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.

#### Power Platform World Tour

Find out where you can attend!

Top Solution Authors
Top Kudoed Authors (Last 30 Days)
Users online (3,864)