topic Re: AND and AND NOT Condition in DAX Commands and Tips

AND and AND NOT Condition

SIBI1998 — Fri, 01 Apr 2022 08:14:16 GMT

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

Re: AND and AND NOT Condition

Anonymous — Fri, 01 Apr 2022 09:44:32 GMT

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)

Re: AND and AND NOT Condition

SIBI1998 — Fri, 01 Apr 2022 13:36:10 GMT

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)

Re: AND and AND NOT Condition

Anonymous — Tue, 05 Apr 2022 06:51:53 GMT

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.