Forum Discussion

ke964's avatar
ke964
New Member
8 years ago
Solved

If statement HELP

All,

 

I am new in Power BI.  I would like to replicate below scenarion:

 

CASE WHEN "Oeorder Detail"."Supply Order No" IS NOT NULL THEN ("Oeorder Release"."Revised Qty Due"- "Oeorder Release"."Qty Shipped"-"Oeorder Release"."Qty Reserved") ELSE 0 END

 

Thank you in advance!

  • Anonymous's avatar
    Anonymous
    8 years ago
    IF(NOT(IS BLANK([CONDITION])), [RESULT], 0)

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago
    IF(NOT(IS BLANK([CONDITION])), [RESULT], 0)
  • ke964's avatar
    ke964
    New Member
    8 years ago

    All,

     

    I am a new user.  I am trying to do an if statement.  This is what I am trying to replicate in Power BI:

     

    CASE WHEN "Oeorder Detail"."Supply Order No" IS NOT NULL THEN ("Oeorder Release"."Revised Qty Due"- "Oeorder Release"."Qty Shipped"-"Oeorder Release"."Qty Reserved") ELSE 0 END

     

    Thank you in advance.