Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to 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
... 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
Thank you. Its working perfectly fine. 🙂
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
... 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
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |