Forum Discussion

SIBI1998's avatar
SIBI1998
Icon for Helper I rankHelper I
4 years ago
Solved

AND and AND NOT Condition

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 i...
DAX
  • Anonymous's avatar
    Anonymous
    4 years ago

    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.

Anonymous's avatar
Anonymous
Not applicable
4 years ago

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's avatar
SIBI1998
Icon for Helper I rankHelper I
4 years ago

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's avatar
    Anonymous
    Not applicable
    4 years ago

    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.