Split Column Based On Criteria

Question

Hello ExpertsI need some advise and help with something I needGot a column "OT Hrs" which I want to conditionally split into two columns based on the below criteria&nbsp;If the value of the column is between 0 to 0.4, then that value goes into a column called Included OTIf the value of the column is &gt;0.4, then 0 to 0.4 value goes to column called Included OT and the balance goes into another column called Extra OT&nbsp;See below some data and results&nbsp;&nbsp;OT HrsIncluded OTExtra OT0000.40.400.650.40.251.650.41.250.90.40.50000.320.3202.40.421.730.41.332.150.41.7530.42.62.420.42.022.030.41.630002.90.42.5000&nbsp;RegardsRah

mussaenda · Accepted Answer

Power Query&nbsp;&nbsp;Included OT
if [OT Hrs] &gt;.4 then .4 else [OT Hrs]Excluded OT
if [OT Hrs] = [Included OT] then 0 else [OT Hrs]-[Included OT]&nbsp;&nbsp;

Forum Discussion

Split Column Based On Criteria

2 Replies

Related content

Splitting Column values

Sequential Order column based on multiple criteria

Split column by two criteria

Split a column into two separate columns

Split Columns

OT Hrs	Included OT	Extra OT
0	0	0
0.4	0.4	0
0.65	0.4	0.25
1.65	0.4	1.25
0.9	0.4	0.5
0	0	0
0.32	0.32	0
2.4	0.4	2
1.73	0.4	1.33
2.15	0.4	1.75
3	0.4	2.6
2.42	0.4	2.02
2.03	0.4	1.63
0	0	0
2.9	0.4	2.5
0	0	0