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

selimovd's avatar
selimovd
Most Valuable Professional
5 years ago

Hey Anonymous ,

 

it looks like it works, but I guess you expected a different result 😉

 

In Power BI you can add a calculated column, that's just a new column in the table. A calculated table is calculated when the file is loaded and then fix. The value won't change based on slicers.

Or you can use a measure. A measure always needs a context and is calculated based on this context.

 

Based on your formula I guess you used a calculated column.

In your screenshot you used a matrix, so rows might be hidden based on your selection.

 

To see if all of your values are existing, go to the Data tab and check the result in the complete table there:

 

If you need any help please let me know.
If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍
 
Best regards
Denis
 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    selimovd 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 = "".