How to create time slots in Power BI data set ?

[sanjeev803]

 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.

[sanjeev803]

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.

[v-yuezhe-msft · Accepted solution]

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

[chbraun · Accepted solution]

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

[sanjeev803 · Accepted solution]

Thank you. Its working perfectly fine. 🙂