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.

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.