Forum Discussion

SIBI1998's avatar
SIBI1998
Helper I
4 years ago
Solved

AND and AND NOT Condition

Hi,

 

          Here I have needed AND and AND NOT Condition for ;

 

I have 5 Stages (Stage1,Stages2,Stages3,Stages4,Stages5) and (Verified Ekyc) as one Column I have Needed Like with the Below Status "Rejected".

 

IF ISNULL([Stage5]) AND NOT ISNULL([Stage4]) AND NOT ISNULL([Stage3]) AND NOT ISNULL([Stage2]) AND NOT ISNULL([Stage1]) AND [Stage1]!='Rejected' AND [Stage2]!='Rejected' AND [Stage3]!='Rejected' AND [Stage4]!='Rejected' AND ISNULL([Verified Ekyc]) THEN 1
END

Need Help
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi SIBI1998 ,

     

    Please try:

    Column = 
IF (
    [Stage1] <> BLANK ()
        && [Stage2] <> BLANK ()
        && [Stage3] <> BLANK ()
        && [Stage4] <> BLANK ()
        && [Stage5] <> BLANK ()
        && [Stage1] <> "Rejected"
        && [Stage2] <> "Rejected"
        && [Stage3] <> "Rejected"
        && [Stage4] <> "Rejected"
        && [Verified Ekyc] <> BLANK (),
    1
)

     

    Best Regards,
    Eyelyn Qin
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

8 Replies

  • SIBI1998's avatar
    SIBI1998
    Helper I
    4 years ago

    Hi,

     

           Here I have an Colum Payment , Stages with (Stage1,Stage2,Stage3,Stage4,Stage5) and Another Column Verified Ekyc.

           

           I have an Sample Formula which I have used in Tableau and Here I need the Same in Power BI.

     

    IF ISNULL([Payment]) AND NOT ISNULL([Stage5]) AND NOT ISNULL([Stage4]) AND NOT ISNULL([Stage3]) AND NOT ISNULL([Stage2]) AND NOT ISNULL([Stage1]) AND ISNULL([Verified Ekyc]) THEN 1
    END

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Hi SIBI1998 , you can try 
      IF(ISBLANK([Payment]) && NOT(ISBLANK([Stage5])) && NOT(ISBLANK([Stage4])) && NOT(ISBLANK([Stage3])) && NOT(ISBLANK([Stage2])) && NOT(ISNULL([Stage1])) && ISBLANK([Verified Ekyc]),
      1)

    • SIBI1998's avatar
      SIBI1998
      Helper I
      4 years ago

      @Aditya_Meshram I have been Coming up with this error while applying the Formula.

       

       IF(ISBLANK([Payment]) && NOT(ISBLANK([Stage5])) && NOT(ISBLANK([Stage4])) && NOT(ISBLANK([Stage3])) && NOT(ISBLANK([Stage2])) && NOT(ISNULL([Stage1])) && ISBLANK([Verified Ekyc]), This is not valid and I have used ISBLANK instead of ISBLANK

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        4 years ago

        The brackets are incorrect.
        Add closing brackets in the places I marked with orange and remove the 6 closing brackets from the end.

  • lbendlin's avatar
    lbendlin
    Super User
    4 years ago

    IF(COALESCE([Stage4],"Rejected")<>"Rejected" && COALESCE([Stage3],"Rejected")<>"Rejected" && COALESCE([Stage2],"Rejected")<>"Rejected" && COALESCE([Stage1],"Rejected")<>"Rejected" && ISBLANK([Stage5]) && ISBLANK([Verified Ekyc]),1)

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi SIBI1998 ,

     

    Please try:

    Column = 
IF (
    [Stage1] <> BLANK ()
        && [Stage2] <> BLANK ()
        && [Stage3] <> BLANK ()
        && [Stage4] <> BLANK ()
        && [Stage5] <> BLANK ()
        && [Stage1] <> "Rejected"
        && [Stage2] <> "Rejected"
        && [Stage3] <> "Rejected"
        && [Stage4] <> "Rejected"
        && [Verified Ekyc] <> BLANK (),
    1
)

     

    Best Regards,
    Eyelyn Qin
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.