Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
manishsalanke
Helper II
Helper II

new conditional column

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"Screenshot 2023-02-14 155331.png

1 REPLY 1
amitchandak
Super User
Super User

@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

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.