IF Excel Function Turned Into DAX

Question

Hello,

Pretty new to Power BI, especially to DAX. Looking to get help writing the following IF function I made in Excel that I would like to recreate in my dashboards;

=IF(B2=<SUM(C2:E2),"Okay",IF(B2>SUM(C2:E2),"Constrained"))
A2 = Item code
B2 = the quantity of an item on a sales order, lets say the cell shows a 5
C2 = current inventory, lets say 4
D2 = purchased items in transit, lets say 3
E2 = Manufactured items in transit, lets say 0

so in the cell the formula is written it should return an "Okay" since we have 7 about to be in stock and need 5 for the sales order. How would I write this out in DAX?

Thank you!

Answer 1

Hi @123456789 ,

Power BI is currently not supported in the Q&A forums, the supported products are listed over here https://learn.microsoft.com/en-us/answers/products (more to be added later on).

You can ask the experts in the dedicated Power BI forum over here:
https://community.powerbi.com/t5/Forums/ct-p/PBI_Comm_Forums

----------

(If the reply was helpful please don't forget to upvote or accept as answer, thank you)

Best regards,
Leon