new conditional column

[manishsalanke]

hi , i need to add a status column containeing pending orders and orders completed and order partial .

in this case the conditon is if del _dt is not blank and dsp_dt is blank then status is "pending" ,

and del_dt not blank and dsp_dt (exclude blanks ) and pcs =dsp_pcs then "completed",

and pcs> dsp pcs and qty>dsp_qty then "parcial"

[amitchandak]

@manishsalanke , You can create a  new column like

Status =  Switch(true() ,

not(isblank([del_dt]))&& not(isblank([dsp_dt])) && [pcs] =[dsp_pcs] , "completed",

[pcs]> [dsp pcs] &&  [qty] > [dsp_qty],  "parcial"

)

Switch-Case statement of #PowerBI: https://www.youtube.com/watch?v=gelJWktlR80&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=56