Calculated column formula Incorrect

[vjnvinod]

Dear all

I am using the below formula, for creating Category using the Inventory Ageing column

Category = IF('Open Orders'[InventoryAgeing]<0,"Production Delay",IF('Open Orders'[InventoryAgeing]>0,"Delayed Sales",IF('Open Orders'[InventoryAgeing]=BLANK(),"No Conclusion",IF('Open Orders'[InventoryAgeing]=0,"Good Business"))))

But the below condition is reading 0 also as blank

IF('Open Orders'[InventoryAgeing]=BLANK(),"No Conclusion"

 how do i fix this?

[vjnvinod]

@parry2k 

thank you very much, worked like a charm

[parry2k · Accepted solution]

@vjnvinod try this:

Category =
VAR __days = 'Open Orders'[InventoryAgeing]
RETURN
SWICH ( TRUE(),
  ISBLANK ( __days ), "No Conclusion",
  __days < 0,  "Production Delay",
  __days > 0, "Delayed Sales",
  __days = 0, "Good Business" 
)

✨ Follow us on LinkedIn and  to our YouTube channel

Check my latest video on Filters and Sparklines https://youtu.be/wmwcX8HvNxc

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.