Forum Discussion

adoalan's avatar
adoalan
Icon for Helper III rankHelper III
3 years ago

Dax Formula help

Hi all,   I have the above formula and I m not sure what Im doing wrong here.   Can you help Thank you  
Need Help
adoalan's avatar
adoalan
Icon for Helper III rankHelper III
3 years ago

I got working this part with if 3 columns are blank 

 

Missing = IF(ISBLANK(nfp_giftaiddeclaration[Surname]) && ISBLANK(nfp_giftaiddeclaration[Forename]) &&  ISBLANK(nfp_giftaiddeclaration[House]), "Y", "N")
 
 
I need this part which says if nfp_declaredfore contains like '%&%' or nfp_declaredsur like '%&%'  then  "Y", "N")