AND and AND NOT Condition

[SIBI1998]

Hi,

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

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

IF (ISNULL([Sign]) or [Sign] == '') AND NOT 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]

Hi @SIBI1998 you can try
IF(ISBLANK([Sign]) || [Sign] = "") && NOT(ISBLANK([Payment])) && NOT(ISBLANK([Stage5])) && NOT(ISBLANK([Stage4])) && NOT(ISBLANK([Stage3])) && NOT(ISBLANK([Stage2])) && NOT(ISBLANK([Stage1])) && ISBLANK([Verified Ekyc],
1)

[SIBI1998]

@Anonymous

I have used the below value and showing the error as,

E-Sign Pending = IF(ISBLANK('TABLEAU_REPORT overview_ekyc'[sign] || 'TABLEAU_REPORT overview_ekyc'[sign] ="") && NOT(ISBLANK('TABLEAU_REPORT overview_ekyc'[payment] && NOT(ISBLANK('TABLEAU_REPORT overview_ekyc'[stage5] && NOT('TABLEAU_REPORT overview_ekyc'[stage4] && NOT(ISBLANK('TABLEAU_REPORT overview_ekyc'[stage3] && NOT('TABLEAU_REPORT overview_ekyc'[stage2] && NOT('TABLEAU_REPORT overview_ekyc'[stage1] && ISBLANK('TABLEAU_REPORT overview_ekyc'[verified_ekyc],1)

[Anonymous · Accepted solution]

Hi @SIBI1998 ,

 Your formula is incomplete, like missing back brackets and missing ISBLANK function, so there will be errors.

Try this calculated column,

E-Sign Pending =
IF (
    (
        ISBLANK ( 'TABLEAU_REPORT overview_ekyc'[sign] )
            || 'TABLEAU_REPORT overview_ekyc'[sign] = ""
    )
        && NOT ( 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
)

What is the difference between Power BI calculated columns and measures? - TrueCue.

Best Regards,

Stephen Tao

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