cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
sanjeev803 Regular Visitor
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 v-yuezhe-msft
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"))))

1.PNG2.PNG


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.

View solution in original post

Highlighted
chbraun Regular Visitor
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

 

View solution in original post

sanjeev803 Regular Visitor
Regular Visitor

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

Thank you. Its working perfectly fine. 🙂 

View solution in original post

4 REPLIES 4
sanjeev803 Regular Visitor
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 v-yuezhe-msft
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"))))

1.PNG2.PNG


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.

View solution in original post

Highlighted
chbraun Regular Visitor
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

 

View solution in original post

sanjeev803 Regular Visitor
Regular Visitor

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

Thank you. Its working perfectly fine. 🙂 

View solution in original post

Helpful resources

Announcements
New Kudos Received Badges Coming

New Kudos Received Badges Coming

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

Microsoft Implementation for Communities Wins Award

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

Power Platform World Tour

Find out where you can attend!

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