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 S...
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.

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)