Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

IF STATEMENT

I wonder why this does not work:   Status 2 = IF('DailyASCPPlan Data'[ORDER_TYPE_TEXT] = "Planned order demand" && ISBLANK('DailyASCPPlan Data'[PROJECT_NUMBER]),"Planned","Ordered")  
Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    Anonymous , This is column can you show in the table view?

     

    Also, check if PROJECT_NUMBER is text, check is it a empty string ""

goncalogeraldes's avatar
goncalogeraldes
Icon for Super User rankSuper User
5 years ago

Try this one: 

 

 

Status 2 = 
var order_type = SELECTEDVALUE('DailyASCPPlan Data'[ORDER_TYPE_TEXT])
var is_blank = ISBLANK('DailyASCPPlan Data'[PROJECT_NUMBER])

return
IF( order_type = "Planned order demand" && is_blank,
      "Planned",
      "Ordered")

 

 

Nevertheless, it may be best to create a "Calculated Column" or a "Custom column" in Power Query.

Hope this answer solves your problem! If you need any additional help please tag me in your reply.
If my reply provided you with a solution, pleased mark it as a solution ✔️ or give it a kudoe 👍
Thanks!

Best regards,
Gonçalo Geraldes

 

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Thank you so much. I appreciate your help. This actually works. Tho i just found out that the actual value is not really blank, rather a "". so i did not use isblank and rather evaluate if field = "".