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

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.

3 Replies

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