AND and AND NOT Condition

[SIBI1998]

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

[SIBI1998]

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

[SIBI1998]

@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]

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

[SIBI1998]

@Aditya_Meshram I have again Came up with this error

[SIBI1998]

@Aditya_Meshram

The Formula which I have Used,

Payment Pending = IF(ISBLANK('TABLEAU_REPORT overview_ekyc'[payment] && NOT(ISBLANK('TABLEAU_REPORT overview_ekyc'[stage5] && NOT(ISBLANK('TABLEAU_REPORT overview_ekyc'[stage4] && NOT(ISBLANK('TABLEAU_REPORT overview_ekyc'[stage3] && NOT(ISBLANK('TABLEAU_REPORT overview_ekyc'[stage2] && NOT(ISBLANK('TABLEAU_REPORT overview_ekyc'[stage1] && ISBLANK('TABLEAU_REPORT overview_ekyc'[verified_ekyc]),1)

[Anonymous]

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)

[Anonymous · Accepted solution]

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.

[lbendlin]

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