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 ""

amitchandak's avatar
amitchandak
Super User
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 ""

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Right. It's "" not blank. thanks for the info!