Forum Discussion

rahul_ferns's avatar
rahul_ferns
Icon for Helper II rankHelper II
2 years ago
Solved

Split Column Based On Criteria

Hello Experts I need some advise and help with something I need Got a column "OT Hrs" which I want to conditionally split into two columns based on the below criteria   If the value of the column...
Need Help
  • mussaenda's avatar
    mussaenda
    2 years ago

    Power Query

     

     

    Included OT
if [OT Hrs] >.4 then .4 else [OT Hrs]
    Excluded OT
if [OT Hrs] = [Included OT] then 0 else [OT Hrs]-[Included OT]

     

     

mussaenda's avatar
mussaenda
Icon for Community Champion rankCommunity Champion
2 years ago

Power Query

 

 

Included OT
if [OT Hrs] >.4 then .4 else [OT Hrs]
Excluded OT
if [OT Hrs] = [Included OT] then 0 else [OT Hrs]-[Included OT]

 

 

  • rahul_ferns's avatar
    rahul_ferns
    Icon for Helper II rankHelper II
    2 years ago

    Hi Mussaenda

    Thanks, that worked

    Much appreciated